Removes all rows from a table.
truncate table [[database.]owner.]table_name
is the name of the table to be truncated.
truncate table authors
The client application passes the truncate table command to the DB2 access service as a language command.
In sybase mode, the DB2 access service converts truncate table to a delete command without a where clause.
