TRUNCATE Statement

• Removes all rows from a table, leaving the table empty and the table structure intact
• Is a data definition language (DDL) statement rather than a DML statement; cannot easily be undone
• Syntax : TRUNCATE TABLE table_name;
• Example : TRUNCATE TABLE copy_emp;