Check if TABLE exist

Check if the table exists before dropping the table.

IF OBJECT_ID(‘dbo.Customer‘) IS NOT NULL
     DROP TABLE dbo.Customer
ELSE
     PRINTTable already exist

Advertisements