|
|
|
TRUNCATE TABLE
Description
Delete all the rows of a table in a single action.
(In V10.3 and later) Any table truncated using TRUNCATE will have the $DELFLD$ set to 4 bytes despite the size in the original table.
Syntax
TRUNCATE TABLE [ table_name ]
Arguments
table_name
Specifies a single table to truncate.
Authorization
The user must have the DBA privilege or SELECT privilege on all the tables in the database. To issue the TRUNCATE TABLE statement for a specific table, the user must be the owner or have UPDATE privilege on the table.
SQL Compliance |
Extension |
Environment |
Embedded SQL, interactive SQL, ODBC applications |
