database concepts

Using a database: creating tables

Deleting the INVOICE database

Question
What order should the tables be deleted in?

Organise the following tables into the correct deletion order by dragging them with your mouse.

Showme

INVOICEITEM,
INVOICE
ITEM
CUSTOMER

Question
What are the SQL statements to delete the INVOICE database?

Tip
This is the reverse order in which the tables were created.

 

 

Show me

DELETE FROM INVOICEITEM;
DROP TABLE INVOICEITEM;
DELETE FROM INVOICE;
DROP TABLE INVOICE;
DELETE FROM ITEM;
DROP TABLE ITEM;
DELETE FROM CUSTOMER;
DROP TABLE CUSTOMER;