HTML tutorial
CSS3 tutorial
Bootstrap tutorial
JavaScript tutorial
JQuery tutorial
AngularJS tutorial
React tutorial
NodeJS tutorial
PHP tutorial
Python tutorial
Python3 tutorial
Django tutorial
Linux tutorial
Docker tutorial
Ruby tutorial
Java tutorial
C tutorial
C ++ tutorial
Perl tutorial
JSP tutorial
Lua tutorial
Scala tutorial
Go tutorial
ASP.NET tutorial
C # tutorial
SQLite TheDROP TABLE statement to remove a table definition and all relevant data, indexes, triggers, constraints, and permission specifications for that table.
When you use this command to pay special attention to, because once a table is deleted, all the information in the table will be lost forever.
The basic syntax for DROP TABLE statement is as follows. You can choose to specify the database name with the table name, as follows:
DROP TABLE database_name.table_name;
Let us make sure COMPANY table already exists, then we will remove it from the database.
sqlite> .tables COMPANY test.COMPANY
This means that the COMPANY table already exists in the database, let's remove it from the database, as follows:
sqlite> DROP TABLE COMPANY; sqlite>
Now, if you try .TABLES command, you will not find the COMPANY table:
sqlite> .tables sqlite>
Showing results is empty, meaning that was successfully removed from the database table.