SQLite - DROP TABLE Statement

In SQLite the DROP TABLE Statement can be used to drop/delete the table in a database.

The DROP TABLE statement not only will remove your table but also all the data, triggers, indexes, constraints and permissions for the table.

Note: While using DROP TABLE statement we need to be careful because once the table is removed all the data related to the table will also be lost.

SQLite DROP TABLE Syntex

The syntex for dropping a table from the database using SQLite is shown below:

DROP TABLE table_name;

Example:

So let's consider we have created SCHOOL database. And we also created two tables called STUDENTS and TEACHERS in this database.

sqlite>.tables
STUDENTS     TEACHERS

So in order to drop the STUDENTS table you be to execute the following command.

sqlite>DROP TABLE STUDENTS;
sqlite>
);

Now if we list down all the tables in the database again using .tables command, we will see the following result.

sqlite>.tables
TEACHERS

SqLite Tutorial

SqLite - HOME SqLite - Intro SqLite - Installation SqLite - Syntax SqLite - Data Types SqLite - Create DB SqLite - Create Table SqLite - Drop Table SqLite - Select SqLite - Distinct SqLite - Where SqLite - And & Or SqLite - Order By SqLite - Insert Into SqLite - Update SqLite - Delete SqLite - Injection SqLite - Select Top SqLite - Like SqLite - Wildcards SqLite - In SqLite - Between SqLite - Aliases SqLite - Joins SqLite - Inner Join SqLite - Left Join SqLite - Right Join SqLite - Full Join SqLite - Union SqLite - Select Into SqLite - Insert Into Select SqLite - Constraints SqLite - Not Null SqLite - Unique SqLite - Primary Key SqLite - Foreign Key SqLite - Check SqLite - Default SqLite - Create Index SqLite - Drop SqLite - Alter SqLite - Auto Increment SqLite - Views SqLite - Dates SqLite - Null Values SqLite - Null Functions SqLite - Data Types SqLite - DB Data Types

SqLite Functions

SqLite - Functions SqLite - Avg() SqLite - Count() SqLite - First() SqLite - Last() SqLite - Max() SqLite - Min() SqLite - Sum() SqLite - Group By SqLite - Having SqLite - Ucase() SqLite - Lcase() SqLite - Mid() SqLite - Len() SqLite - Round() SqLite - Now() SqLite - Format()