Description
The following operations can be performed using the MODIFY statement:
• 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).
Last modified date: 01/30/2023