Table of Contents
TRUNCATE
The speedy way to delete all records of a table.
Syntax
truncate_statement
: TRUNCATE [TABLE] table_name
table_name is the table which contains the records to be deleted.
TRUNCATE TABLE tbl1
Restrictions
The table should satisfy the following requirements:
- there are no on-delete triggers;
- there are no links.