Removes
all rows from a table.
Syntax
Transact-SQL Syntax
truncate table [[database.]owner.]table_name
ODBC Syntax
Not supported.
The command can be transformed into an equivalent
delete command as:
DELETE FROM table_name
Parameters
- table_name – is the
name of the table to be truncated.
Usage
Adaptive Server/CIS passes the command to the DirectConnect server as a language event.