Table of Contents
SQL DROP TABLE Statement
In SQL, the DROP TABLE statement is used to delete the existing table from the database.
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.
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.