SQL Server - SQL Table Basics - Drop Table

Drop table

Of course, be careful using this function.

drop table person

Note: You cannot drop a table that is referenced by a foreign key constraint. This is a very good thing. So, in the above example the only way to drop the person table would be to also drop the address table and the phone table.