If we want to remove a table, we use the DROP TABLE command followed by the name of the table, we want removed. When the table is dropped, it is completely removed from the database and all the data inside the table is thrown away.
|--- SQL command to drop table ---|
|DROP TABLE tableName;|
To remove the Ducks table, we give the command DROP TABLE Ducks. Hereafter, the table is permanently removed. Unless we have a backup or other means of recovering the data, we would have to recreate from the bottom if we wanted the Ducks’ original content back.
|--- SQL command to drop the table named Ducks ---|
|DROP TABLE Ducks;|