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
Subscribe to:
Post Comments (Atom)
No comments:
Post a Comment