Explain TRUNCATE TABLE in SQL ?

The TRUNCATE TABLE command is used to delete complete data from an existing table.

 

Syntax:

 

TRUNCATE TABLE  table_name;

 

Note: Truncate will remove the data permanently we cannot rollback the deleted data.