TRUNCATE TABLE

Data Model > Accessing the UNICOM Intelligence Data Model > Working with the Case Data Model > SQL syntax > Data manipulation statements > TRUNCATE TABLE

TRUNCATE TABLE

The TRUNCATE TABLE statement removes all rows from a table.

The TRUNCATE TABLE statement is the equivalent of using the DELETE statement without a WHERE clause. However, deleting all the rows of a table using the TRUNCATE TABLE statement is generally faster than using the DELETE statement.

Syntax

TRUNCATE TABLE
table

Example

TRUNCATE TABLE vdata

Requirements

UNICOM Intelligence Data Model