MySQL Drop TableDeleting tables. MySQL DROP TABLE Statement The DROP TABLE statement is used to drop an existing table in a database. Be careful! Dropping a table deletes the table definition AND all its data! If you just want to delete the data but keep the table, use TRUNCATE TABLE. ExampleDROP TABLE Shippers;Try it Yourself PreviousNext