Home Forums SQL Server 2005 T-SQL (SS2K5) drop table if exists RE: drop table if exists
ian_dunlop2000
SSC-Addicted
Points: 430
More actions
April 2, 2008 at 3:47 am
#797071
Use below replace GOLD_BROKER_OUTPUT WITH THE TABLE YOU NEED TO DROP IS EXISTS
IF EXISTS (SELECT * FROM sys.objects WHERE object_id = OBJECT_ID(N'[dbo].[GOLD_BROKER_OUTPUT]') AND type in (N'U'))
DROP TABLE [dbo].[GOLD_BROKER_OUTPUT]