TRUNCATE¶

Synopsis¶

TRUNCATE TABLE table_name

Description¶

Delete all rows from a table.

Examples¶

Truncate the table orders:

TRUNCATE TABLE orders;

Limitations¶

Some connectors have limited or no support for TRUNCATE. See connector documentation for more details.