HIVE DROP TABLE Statement
The DROP TABLE statement is used to drop an existing HIVE table.
Syntax:
DROP TABLE <tablename>
DROP TABLE Example
The following HIVE statement deletes a table called "Employee":
DROP TABLE Employee;
Note : For an external table the data won't be removed. However the table will be deleted.