SQLite Tutorial SQLite Advanced SQLite Database SQLite References

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.

Note: Be careful before dropping a table. Once deleted, all information stored in that table will be lost forever!.

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:

EmpIDNameCityAgeSalary
1JohnLondon253000
2MarryNew York242750
3JoParis272800
4KimAmsterdam303100
5RameshNew Delhi283000
6HuangBeijing282800

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:

cidnametypenotnulldflt_valuepk
0EmpIDINT11
1NameVARCHAR(255)10
2CityVARCHAR(100)00
3AgeINT00
4SalaryDECIMAL(18,2)00

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

❮ SQLite Keywords