Thursday, May 11, 2017

SQL Server: Drop tables

SQL Server - Drop temporary table



IF OBJECT_ID('tempdb..#DispenseTrans') IS NOT NULL
  DROP TABLE #DispenseTrans
GO



SQL Server - Drop permanent table



IF OBJECT_ID('esdispense', 'U') IS NOT NULL
  DROP TABLE esdispense
GO



No comments:

Post a Comment