Drop Table SQLite

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”.

Please follow and like us:
Content Protection by DMCA.com