Empties a table of all rows.
TRUNCATE [TABLE] <name> [, ...] [CASCADE | RESTRICT]
TRUNCATE quickly removes all rows from a table or set of tables.This is most useful on large tables.
Only the owner of a table may
TRUNCATE will not perform the following:
Run any user-defined
ON DELETEtriggers that might exist for the tables.
Note: HAWQ does not support user-defined triggers.
Truncate any tables that inherit from the named table. Only the named table is truncated, not its child tables.
Empty the table
There is no
TRUNCATE command in the SQL standard.