TRUNCATE TABLE

<< Click to Display Table of Contents >>

Navigation:  Streaming SQL Reference Guide >

TRUNCATE TABLE

Previous pageReturn to chapter overviewNext page

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

truncate_table_02

Example

TRUNCATE TABLE emps;

Limitations

You cannot truncate a view, stream or foreign table.