1.4.12.10 DROP Table

1.4.12.10.1 Delete a Table

To delete a table (the table structure and attributes will also be deleted):

DROP TABLE table_name

Note: If you are using foreign key constraints you cannot drop a parent table if the child table still exists you should drop the child table first.

If you want to drop more than one table you can use this alternative syntax:

DROP TABLE table1, table2, table3