# DROP TABLE

### Description

DROP TABLE deletes the table and removes the directory associated with the table from the file system if the table is not EXTERNAL table. If the table is not present it throws an exception.

In case of an external table, only the associated metadata information is removed from the metastore database.

If the table is cached, the command uncaches the table and all its dependents.

### Syntax

DROP TABLE [ IF EXISTS ] table_identifier


### Parameter

• IF EXISTS

If specified, no exception is thrown when the table does not exist.

• table_identifier

Specifies the table name to be dropped. The table name may be optionally qualified with a database name.

Syntax: [ database_name. ] table_name

### Examples

-- Assumes a table named employeetable exists.
DROP TABLE employeetable;

-- Assumes a table named employeetable exists in the userdb database
DROP TABLE userdb.employeetable;

-- Assumes a table named employeetable does not exist.
-- Throws exception
DROP TABLE employeetable;
-- Assumes a table named employeetable does not exist,Try with IF EXISTS