truncate table command

When the server receives the truncate table command, it passes the command to an appropriate access method, if the object on which the command is to operate has been associated with a remote or external storage location.

The command is reconstructed using a syntax appropriate for the class and is passed to the remote server for execution. Since this syntax is unique to the Adaptive Server environment, a server of class db2 would receive a delete command with no qualifying where clause:

delete from t1

The truncate table command is passed to remote servers as a language request.