2 Ways are there to Delete A Temp Table
1st Way
2nd Way
IF EXISTS (SELECT * FROM sys.objects WHERE object_id = OBJECT_ID(N'[dbo].[Table]')
AND type in (N'U'))
DROP TABLE [dbo].[Table]
1st Way
IF OBJECT_ID('tempdb..#mytemptable') > 0 DROP TABLE #mytemptable
2nd Way
IF EXISTS (SELECT * FROM sys.objects WHERE object_id = OBJECT_ID(N'[dbo].[Table]')
AND type in (N'U'))
DROP TABLE [dbo].[Table]
No comments:
Post a Comment