Tuesday, August 5, 2008

T-SQL - Check if Table Exists in Database System

IF EXISTS (SELECT * FROM dbo.sysobjects WHERE id = OBJECT_ID(N'[dbo].[TableName]') AND OBJECTPROPERTY(id, N'IsUserTable') = 1)
BEGIN
DROP TABLE [dbo].[TableName]
END
GO

No comments: