1.11.1. Grammar ¶

The basic syntax of the DROP TABLE statement is as follows. You can choose to specify a database name with a table name, as follows:

DROP TABLE database_name.table_name;

1.11.2. Example ¶

Let’s first confirm that the COMPANY table already exists, and then we delete it from the database.

sqlite>.tables
COMPANY       test.COMPANY

This means that the COMPANY table already exists in the database, so let’s delete it from the database as follows:

sqlite>DROP TABLE COMPANY;
sqlite>

Now, if you try the .tables command, you will not be able to find the COMPANY table:

sqlite>.tables
sqlite>

The display result is empty, which means that the table has been successfully deleted from the database.