8. SQL Statements : MODIFY : Syntax for Modify Operations
 
Share this page                  
Syntax for Modify Operations
Use the syntax shown below to perform the listed operation:
Reorganize a btree table's index:
[EXEC SQL] MODIFY table_name|indexname TO MERGE
Move a table:
[EXEC SQL] MODIFY table_name|indexname TO RELOCATE
    WITH oldlocation = (locationname {, locationname}),
        newlocation = (locationname {, locationname}),
Change locations for a table:
[EXEC SQL] MODIFY table_name|indexname TO REORGANIZE
    WITH LOCATION = (locationname {, locationname})
Delete all data in a table:
[EXEC SQL] modify table_name|indexname TO TRUNCATED
Add pages to a table:
[EXEC SQL] 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:
[EXEC SQL] MODIFY table_name|indexname TO ADD_EXTEND
    [WITH BLOB_EXTEND = number_of_pages]
where number_of_pages is 1 to 8,388,607.
Mark a table as physically consistent/inconsistent:
[EXEC SQL] MODIFY table_name|indexname TO PHYS_CONSISTENT|PHYS_INCONSISTENT
Mark a table as logically consistent/inconsistent:
[EXEC SQL] MODIFY table_name|indexname  TO LOG_CONSISTENT|LOG_INCONSISTENT
Mark a table as allowed or disallowed for table-level recovery:
[EXEC SQL] MODIFY table_name|indexname TO
    TABLE_RECOVERY_ALLOWED|TABLE_RECOVERY_DISALLOWED
Defer the uniqueness check until the end of statement execution:
[EXEC SQL] MODIFY table_name TO UNIQUE_SCOPE = statement
Mark a table as readonly:
[EXEC SQL] MODIFY table_name TO [NO]READONLY
Assign a table fixed cache priority:
[EXEC SQL] MODIFY table_name TO PRIORITY = cache_priority
Change a table's partitioning scheme:
[EXEC SQL] MODIFY table_name TO RECONSTRUCT
WITH PARTITION = ( partitioning-scheme )
Enable a table modification to be performed online:
[EXEC SQL] MODIFY table_name TO HASH ON col WITH CONCURRENT_UPDATES
Enable access to a table with encrypted columns:
[EXEC SQL] MODIFY table_name TO ENCRYPT
WITH PASSPHRASE='encryption passphrase'
Disable access to a table with encrypted columns:
[EXEC SQL] MODIFY table_name TO ENCRYPT
WITH PASSPHRASE=''
Change the passphrase for a table with encrypted columns:
[EXEC SQL] MODIFY table_name TO ENCRYPT
WITH PASSPHRASE='encryption passphrase',
    NEW_PASSPHRASE='new encryption passphrase'