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