SQL Tutorial Home

How to Drop a Table in MS-SQL

To drop a table, just do:

drop table employee;

If the table doesn’t exist the drop will fail, then in order to avoid this potential error you can use if exists after drop table:

drop table if exists employee;