Sunday, February 26, 2012

Drop #Temporary Table

I created the #Temporary table in MS SQL. Now i want to drop this #Temporary table, but i want to check first before i drop the this table. How to check the Temporary table exist or not in MS SQL?IF Object_ID('tempdb..#mytable') Is NOT NULL
DROP #mytable|||This one will actually work. (grin)

IF OBJECT_ID('tempdb..#mytable') IS NOT NULL
DROP TABLE #mytable|||DOH! (Who says intelligent posts can't be less than 10 characters?)|||I Test on it already, it really work, thankx! Every body

No comments:

Post a Comment