Switch to: V9V8V7V6V5
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:

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