Tables are deleted with DROP TABLE.

DROP TABLE <table_name>;

Foreign Key Constraints

When a table is referenced in another table as a foreign key, the table holding the foreign key must be deleted first.