Drop Table SQLite

by

SQLite Drop Table
To remove a table, the DROP TABLE statement is used in SQLite. It also eliminates the definition and all the associated data, constraints, triggers, indexes, and permission specifications of the specified table. It removes the data permanently.

Syntax: 

DROP TABLE database_name.table_name;

Example: 

DROP TABLE TEACHERS;

Explanation:
In the above example, we dropped a table named “TEACHERS”. To check all the remaining table in the database, use the command “.tables”.