Script(s)

technology as-is

December 4, 2007
by gchandra
0 comments

SQL Server 2005 : Verify table already exists

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’, … Continue reading