Use the Truncate command to remove all rows from a table and reset the STORAGE parameters to the values when the table or cluster was created.

Prerequisites

The table or cluster must be in your schema, or you must have DROP ANY TABLE system privilege.