SQL Table Truncate

It is used to remove all the rows from table and save permanently in database

It will not support where clause

  Truncate = Delete + Commit;

Syntax:

Truncate table <Table_Name>;

Example:

TRUNCATE TABLE Emp;

TRUNCATE TABLE Student;