To Delete the complete data from the table we can use the TRUNCATE TABLE command. Up to some extent, it is similar to the DROP Table command but the difference is DROP TABLE delete the complete table include the table data whereas TRUNCATE command only delete the table data the table would still be there.
SQL TRUNCATE TABLE Command
<NOTE> be careful when you use the TRUNCATE TABLE command.
It Deletes the complete table include.
DROP TABLE table_name;
It only deletes the table data.
TRUNCATE TABLE table_name;
- It only deletes the table data.
- The table would still be present in the table database.