8. SQL Statements : MODIFY : Modify...to Truncated
 
Share this page                  
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. 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.