SQL DROP TABLE
There are times in database administration where a table is no longer needed and needs to be removed. Whether it is to save space, reduce complexity in the database design, or because the table was temporary in nature, the DROP command can be useful to clear space in the database.
The DROP TABLE command will first delete data from the table, and then remove it from the database space. All data is wiped out from the table!
Because of the power of this command, most database systems secure this function. In Oracle, for example, the Database Administrator (DBA) must have system privileges to run DROP TABLE.
With thanks to Study.com