SQL Server - SQL Table Basics - Drop Table
Of course, be careful using this function.
drop table person GO
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.