The DELETE statement is used to delete existing records in a table.

The DROP statement is used to delete existing table.

DELETE FROM table_name
WHERE condition;

DO NOT omit WHERE if you don’t want to delete all records in the table.

Delete one record

DELETE FROM Customers 
WHERE CustomerName='Alfreds Futterkiste';

Delete all records

DELETE FROM table_name;

Delete a Table

DROP TABLE table_name;