Syntax for Modify Operations
Use the syntax shown below to perform the listed operation:
• Reorganize a btree table's index:
modify table_name|indexname to merge
• Move a table:
modify table_name|indexname to relocate
with oldlocation = (locationname {, locationname}),
newlocation = (locationname {, locationname}),
• Change locations for a table:
modify table_name|indexname to reorganize
with location = (locationname {, locationname})
• Delete all data in a table:
modify table_name|indexname to truncated
• Add pages to a table:
modify table_name|indexname to add_extend
[with extend = number_of_pages]
where:
number_of_pages is 1 to 8,388,607.
• Add pages to blob extension table:
modify table_name|indexname to modify-option
with blob_extend [,extend = number_of_pages]
where:
number_of_pages is 1 to 8,388,607.
• Mark a table as physically consistent or inconsistent:
modify table_name|indexname to phys_consistent|phys_inconsistent
• Mark a table as logically consistent or inconsistent:
modify table_name|indexname to log_consistent|log_inconsistent
• Mark a table as allowed or disallowed for table-level recovery:
modify table_name|indexname to
table_recovery_allowed|table_recovery_disallowed
• Defer the uniqueness check until the end of statement execution:
modify table_name to modify-action with unique_scope = statement
• Mark a table as readonly:
modify table_name to [no]readonly
• Assign a table fixed cache priority:
modify table_name to modify-action with priority = cache_priority
• Change a table's partitioning scheme:
modify table_name to reconstruct
with partition = (partitioning-scheme)
• Enable a table modification to be performed online:
modify table_name to modify-option with concurrent_updates
• Enable access to a table with encrypted columns:
modify table_name to encrypt
with passphrase='encryption passphrase'
• Disable access to a table with encrypted columns:
modify table_name to encrypt
with passphrase=''
• Change the passphrase for a table with encrypted columns:
modify table_name to encrypt
with passphrase='encryption passphrase',
new_passphrase='new encryption passphrase'