IF EXISTS (SELECT 1 FROM sys.indexes WHERE name = 'emp_department_ix') DROP INDEX emp_department_ix ON employees; IF EXISTS (SELECT 1 FROM sys.indexes WHERE name ...
IF OBJECT_ID(N'dbo.order_items', N'U') IS NOT NULL DROP TABLE dbo.order_items; IF OBJECT_ID(N'dbo.orders', N'U') IS NOT NULL DROP TABLE dbo.orders; IF OBJECT_ID(N'dbo ...