Verifying that an object exists If the table exists, it is deleted. If the table does not exist, the DROP TABLE statement is not executed. IF OBJECT_ID (N’dbo.AWBuildVersion’, N’U’) IS NOT NULL ┬áDROP TABLE dbo.AWBuildVersion; GO Syntax : OBJECT_ID (‘object_name’, [‘object_type’]) Object Type is optional, and possible values it can hold are.. (Items in bold… (0 comment)