8. SQL Statements : MODIFY : Description
 
Share this page                  
Description
The MODIFY statement enables the following operations to be performed:
Change the storage structure of the specified table or index
Specify the number of pages allocated for a table or index, and the number of pages by which it grows when it requires more space
Add pages to a table
Reorganize a btree index
Move a table or index, or portion thereof, from one location to another
Spread a table over many locations or consolidate a table onto fewer locations
Delete all rows from a table and release its file space back to the operating system
Specify whether an index is recreated when its base table is modified
Specify how unique columns are checked during updates: after each row is inserted or after the UPDATE statement is completed
Mark table as physically or logically consistent or inconsistent
Mark table as allowed/disallowed for table-level recovery
Defer uniqueness check until the end of statement execution
Mark a table as read only
Assign a table fixed cache priority
Change a table's partitioning scheme
Enable modify table to be performed online
Enable or disable access to a table with encrypted columns
Change the encryption passphrase used to access encrypted data
You can change a table's location and storage structure in the same MODIFY statement.
The MODIFY statement operates on existing tables and indexes. When modifying a table to change, truncate, or reconstruct the storage structure, the DBMS Server destroys any indexes that exist for the specified table (unless the index was created with persistence, or the table is a btree and the table being modified to reorganize its index).