SQLite DROP TABLE articulation is utilized to eliminate a table definition and all related information, files, triggers, imperatives, and authorization details for that table.
You must be cautious while utilizing this order in light of the fact that once a table is erased then all the data accessible in the table would likewise be lost for eternity.
Syntax
Following is the fundamental sentence structure of DROP TABLE articulation. You can alternatively determine the data set name alongside table name as follows −
DROP TABLE database_name.table_name;
Example
Allow us first to check COMPANY table and afterward we will erase it from the information base.
sqlite>.tables
COMPANY test.COMPANY
This implies COMPANY table is accessible in the information base, so let us drop it as follows −
sqlite>DROP TABLE COMPANY;
sqlite>
Presently, on the off chance that you attempt .TABLES order, at that point you won't discover COMPANY table any longer.
sqlite>.tables
sqlite>
It shows nothing which implies the table from your data set has been dropped effectively.