When you select a "DROP TO" from SQL SSMS, this is the SQL that generates...

USE [database]

GO

IF EXISTS (SELECT * FROM dbo.sysobjects WHERE id = OBJECT_ID(N'[dbo].

') AND OBJECTPROPERTY(id, N'IsUserTable') =...