Using the ONLY and TABLE Keywords

For Extended Parallel Server, the TABLE keyword and the ONLY keyword have no effect on this statement, but they can be included to make your code more legible for human readers. All of the following statements have the same effect, deleting all rows and any related index data from the customer table:

TRUNCATE ONLY TABLE customer

TRUNCATE TABLE customer

TRUNCATE ONLY customer

TRUNCATE customer