SQLite DROP TABLE statement

The SQLite DROP TABLE statement is used to remove a table from a database.

The syntax of the DROP TABLE statement in SQLite is as follows:

DROP TABLE IF EXISTS tablename;

This will remove specified table from the database, unless constraints such as e.g. the foreign key constraints, are violated.

Close

Meta