TRUNCATE TABLE

Description

Delete all the rows of a table in a single action.

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.