Dropping Tables

Tables are dropped using the DROP TABLE command or through Enterprise Manager. The command to drop the sales table would be as follows:

Drop table sales 

Multiple tables, separated by commas, can be referenced in a single DROP TABLE command. If a foreign key references a table, the referencing table or foreign key constraint must be dropped first. Any triggers and constraints associated with the table are also dropped when the table is dropped. To drop a table in Enterprise Manager, right-click the table in the Details pane and select Delete.

    Part III: SQL Server Administration
    Part IV: Transact-SQL
    Part V: SQL Server Internals and Performance Tuning
    Part VI: Additional SQL Server Features