In This Article, You Will Know About SQL DROP TABLE Statement.
Before moving ahead, let’s know a bit about the SQL DROP TABLE Statement.
Table of Contents
SQL DROP TABLE Statement
In SQL, the DROP TABLE statement is used to delete the existing table from the database.
Syntax
DROP TABLE table_name;
Example: Use DROP TABLE statement to delete a table called “Student_Information”.
DROP TABLE Student_Inforfmation;
Note: DROP TABLE statement will delete the whole table completely.
SQL TRUNCATE TABLE
In SQL, TRUNCATE TABLE statement is used to delete the only data instead of the table.
Syntax
TRUNCATE TABLE table_name;
Example: Use TRUNCATE TABLE statement to delete only the table’s data called “Student_Information”.
TRUNCATE TABLE Student_Inforfmation;
If you find anything incorrect in the above-discussed topic and have further questions, please comment below.
Connect on:
