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
See also
DELETE
SQL syntax
Data manipulation statements