Removes all rows from a table.
truncate table [[database.]owner.]table_name
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.
Component Integration Services forwards the truncate table command to servers of class ASEnterprise.
Component Integration Services forwards the truncate table command to servers of class ASAnywhere.
Component Integration Services forwards the truncate table command to servers of class ASIQ.
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
The following syntax is forwarded to the remote server:
delete from [owner.]table_name
truncate table in the Reference Manual
