TRUNCATE TABLE command is used to delete complete data from an existing table.
TRUNCATE TABLE doesn't delete the structure of the table.
TRUNCATE TABLE table_name;
Let's perform the truncate operation on a database table.
Consider we've an Students table in our database with the following records:
The following command removes all the rows from the Students table:
TRUNCATE TABLE Students;
Now, after executing the above MySQL statement,
You can also use DROP TABLE command to delete complete table but it would remove complete table structure form the database