Truncate Table
TRUNCATE command is used to truncate a table. If you truncate a table, all the rows of the table are deleted permanently.
Syntax:
- TRUNCATE <tablename>
Example:
We have a table named "student" having the following data:
Now, we use TRUNCATE command:
- TRUNCATE student;
Now, the table is truncated. You can verify it by using SELECT command.
- SELECT * FROM student;
You can see that table is truncated now.
