DROP TABLE

Drop table will delete the table

DROP TABLE [table_name];

DROP table with foreign key

In the normal drop, there is no foreign key to worried about. But when you need to drop a table that have a foreign key constraint, the Reference Integrity Constraint comes in. So we need to revoke the constraint check for a while

SET FOREIGN_KEY_CHECKS = 0;
DROP TABLE employee;

and do not forget to turn the check on

SET FOREIGN_KEY_CHECKS = 1;