TRUNCATE TABLE

Use the TRUNCATE statement to remove all rows from a table. TRUNCATE cannot be rolled back. This is faster than doing a DELETE as no logging is involved. For more details, see the topic DELETE in this guide.

Syntax

Example

TRUNCATE TABLE emps;

Limitations

You cannot truncate a view, stream or foreign table.