DROP Table

Remarks#

DROP TABLE removes the table definition from the schema along with the rows, indexes, permissions, and triggers.

Simple drop

Drop Table MyTable;

Check for existence before dropping

DROP TABLE IF EXISTS MyTable;

DROP TABLE IF EXISTS MyTable;

If Exists(Select * From Information_Schema.Tables
          Where Table_Schema = 'dbo'
            And Table_Name = 'MyTable')
  Drop Table dbo.MyTable

DROP TABLE IF EXISTS MyTable;