TRUNCATE

Speedy way to delete all records of a table.

truncate_statement
    : TRUNCATE [TABLE] table_name

table_name is the table which contains the records to be deleted.

TRUNCATE TABLE tbl1

Table should satisfy the following requirements:

1. there are no on-delete triggers;
2. there are no links.