Syntax: 

DROP TABLE [ IF EXISTS ] [catalog-name.]table-name            
	

The DROP TABLE statement removes a table added with the CREATE/REPLACE TABLE statement. The table specified in table-name is completely removed from the database schema and the disk file and cannot be recovered. All indices and triggers associated with the table are also deleted.

The DROP TABLE statement does not reduce the size of the database file. The empty space in the database is retained for later INSERT commands.

The optional IF EXISTS clause suppresses the error that would normally result if the table does not exist.