truncate table

Description

Removes all rows from a table.

Syntax

truncate table [[database.]owner.]table_name

Usage

Comments

Component Integration Services processes the truncate table command when the table on which it operates has been created as a proxy table.
When Component Integration Services forwards the truncate table command to a remote server, the table name used is the remote table name. This name may not be the same as the local proxy table name.

Server Class ASEnterprise

Component Integration Services forwards the truncate table command to servers of class ASEnterprise.

Server Class ASAnywhere

Component Integration Services forwards the truncate table command to servers of class ASAnywhere.

Server Class ASIQ

Component Integration Services forwards the truncate table command to servers of class ASIQ.

Server Class sql_server

Component Integration Services forwards the truncate table command to servers of class sql_server.

Server Class direct_connect and sds

If the remote server has requested DB2 syntax, the following statement is forwarded:
```
delete from [owner.]table_name
```
Otherwise, Transact-SQL syntax is sent:
```
truncate table [[database.]owner.]table_name
```

Server Class db2

The following syntax is forwarded to the remote server:
```
delete from [owner.]table_name 
```

See also

truncate table in the Adaptive Server Reference Manual.