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.