SQLite using tutorial 7 to delete a table

Http://www.runoob.com/sqlite/sqlite-drop-table.html

SQLite Delete Table

The Drop table statement from SQLite is used to delete the table definition and all its related data, indexes, triggers, constraints, and permission specifications for the table.

Use this command with special care, because once a table is deleted, all information in the table will be lost forever.

Grammar

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

DROP TABLE Database_name.table_name;

　　

Instance

Let's first confirm that the company table already exists, and then we'll remove it from the database.

Sqlite>.tablescompany       Test.company

This means that the company table already exists in the database, then let's remove it from the database as follows:

Sqlite>drop TABLE company;sqlite>

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

Sqlite>.tablessqlite>

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

SQLite using tutorial 7 to delete a table