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