database concepts

Using a database: creating tables

Dropping tables

Tables must dropped in the reverse order they were created in (a child table is dropped before the parent table).

For example, if the ITEM table had to be dropped from the INVOICE database, theINVOICEITEM table has to be dropped first. Invoices can't refer to items that are not in the database.

The statements to drop the ITEM table are:

DELETE FROM ITEM;
DROP TABLE ITEM;