TRUNCATE

TRUNCATE:

• This command is use delete records permanently from the existing table.
• It is used to remove all rows from a table and to release the STORAGE SPACE used by the specific TABLE.
• The TRUNCATE TABLE will not facilitate for ROLLBACK.
• To TRUNCATE a Table must be the WONER of the Table.

Syntax:

Truncate table <table name>

Ex:

SQL>truncate table emp;

SQL>truncate table employee;