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;