# DROP Table

# 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;

# Simple drop

Drop Table MyTable;

# Remarks

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

← TRUNCATE DROP or DELETE Database →