In SQLite, DROP TABLE statement is used to remove a table definition and all associated data, indexes, triggers, constraints and permission specifications associated with that table.
DROP TABLE database_name.table_name;
Let's take an example to demonstrate how to delete a table in SQLite.
We have already two tables "DEPARTMENT" and "STUDENT". We can verify it by using .tables command.
So you can see that we have two tables.
Let's delete the "STUDENT" table.
DROP TABLE STUDENT;
You can verify it by using .tables command.
You can see only one table is here in the database. It means the other table is dropped.