MODIFY...TO TRUNCATED
To delete all the rows in the table and release the file space back to the operating system, specify MODIFY...TO TRUNCATED.
Syntax to delete all data in a table:
MODIFY tablename|indexname TO TRUNCATED
For example, the following statement deletes all rows in the acct_payable table and releases the space:
MODIFY acct_payable TO TRUNCATED;
Using TRUNCATED converts the storage structure of the table to heap. The with_clause options cannot be specified when using MODIFY...TO TRUNCATED.
Last modified date: 11/28/2023