how do I drop a table if its exists 2

[DougP]

this is what I have so far
I know its in the 'benchmark' database

if exists table1 in information_schema.tables
drop table table1


DougP, MCP, A+

 

[DotNetGnat]

if Exists ( SELECT * from mydb.dbo.Sysobjects
WHERE xtype='U' and name='table1')
begin
Drop Table table1
End

-DNG

 

[DougP]

thank you
get a star

DougP, MCP, A+

 

[DotNetGnat]

thanks for the star...glad to help...

-DNG

 

[TysonLPrice]

Just another way to skin that cat:

if object_id('tempdb..#TempTable') is not null
drop table #TempTable