Was this helpful?
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: 08/29/2024