SQLite DROP TABLE Keyword

The SQLite DROP TABLE keyword is used to delete a table from the database. It drops all the data, indexes, triggers, constraints and permission specifications for the specified table.

Syntax

The syntax of using DROP TABLE keyword is given below:

DROP TABLE [IF EXISTS] table_name;

The IF EXISTS is an optional parameter that conditionally drops table only if it exists on the database. If a table is deleted which does not exist, it will raise an error.

Example:

Consider a database containing a table called Employee with the following records:

The description of the table can be checked using pragma table_info statement as shown below:

pragma table_info('Employee');

This will produce the result as shown below:

To delete this table, the statement is shown below:

DROP TABLE Employee;

After dropping the table, the pragma table_info statement will return NULL:

pragma table_info('Employee');	
Result: NULL