4. SQL Statements : MODIFY : MODIFY...TO RECONSTRUCT Statement
 
Share this page                  
MODIFY...TO RECONSTRUCT Statement
The MODIFY...TO RECONSTRUCT statement rewrites all data of a table or database.
Note:  MODIFY...TO RECONSTRUCT consumes much time and disk space.
This command has the following format:
MODIFY tablename TO RECONSTRUCT
MODIFY...TO RECONSTRUCT Examples
Apply updates to the sales_dimen table by rewriting the entire table:
MODIFY sales_dimen TO RECONSTRUCT
Note:  To conserve time and disk space, consider using MODIFY...TO COMBINE instead, which typically does not rewrite the entire table.