Check if TABLE exist

Posted on Updated on

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