TRUNCATE

    Description

    quickly removes all rows from a table or set of tables.This is most useful on large tables.

    Required. The name (optionally schema-qualified) of a table to be truncated.

    CASCADE

    RESTRICT

    Since this key word applies to foreign key references (which are not supported in HAWQ) it has no effect.

    Notes

    Only the owner of a table may TRUNCATE it. will not perform the following:

    • Note: HAWQ does not support user-defined triggers.

    Empty the table :

    1. TRUNCATE films;

    Compatibility