CodesJava

Easy learning with example program codes

Drop Table in 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:
error









Copyright © 2019 CodesJava DMCA.com Protection Status