|TEMPORARY||Optional. It specifies that only temporary tables should be dropped by the DROP TABLE statement.|
|IF EXISTS||Optional. If specified, the DROP TABLE statement will not raise an error if one of the tables does not exist.|
Drop Table is used to delete the table from database.
Creating a table named tbl and then deleting the created table
CREATE TABLE tbl( id INT NOT NULL AUTO_INCREMENT, title VARCHAR(100) NOT NULL, author VARCHAR(40) NOT NULL, submission_date DATE, PRIMARY KEY (id) );
DROP TABLE tbl;
Dropping table will completely delete the table from the database and all its information, and it will not be recovered.
DROP TABLE Database.table_name