Parameters—Modify Statement
This statement has the following parameters:
modify-action
Specifies how the table should be modified. The modify-action can be any one of the following keywords:
isam
Modifies the table storage structure to the ISAM structure.
hash
Modifies the table storage structure to the HASH structure
heap
Modifies the table storage structure to the HEAP structure
heapsort
Modifies the table storage structure to the HEAP structure, and additionally sort the rows in the table as directed
btree
Modifies the table storage structure to the BTREE structure
reconstruct
Modifies the table storage structure to what it currently is (the table is physically rebuilt)
truncated
Truncates the table, deleting all data
reorganize
Moves the data to a different location
relocate
Moves the table to a different location
merge
Shrinks a btree index
add_extend
Adds disk pages to the table
[no]readonly
Marks the table read only or not read only
phys_[in]consistent
Marks the table physically consistent or inconsistent
log_[in]consistent
Marks the table logically consistent or inconsistent
table_recovery_[dis]allowed
Allows or disallow table level rollforward
[no]persistence
Marks the index to be recreated automatically as needed (secondary indexes only)
table_debug
Displays internal table data structures
encrypt
Enables or disables encryption for the table. Must be used with the with passphrase clause. For more information on data encryption, see the Ingres Security Guide.
The additional action_keywords cheap, chash, cisam, and cbtree are accepted. cheap is a synonym for heap with compression=(data), and the others similarly. These forms are deprecated; the with compression= clause should be used instead.
One of the storage structure actions (heap, hash, isam, btree) can be used instead of reconstruct.
unique
Requires each key value in the restructured table to be unique. This clause is used only with the isam, hash, or btree modify-actions.
on column-name
Determines the storage structure keys of the table. This clause is used only with isam, hash, btree, or heapsort actions.
with_clause
Specifies with clause parameters consisting of the word with followed by a comma-separated list of any number of the following items:
• allocation = n
• extend = n
• fillfactor = n (isam, hash, and btree only)
• minpages = n (hash only)
• maxpages = n (hash only)
• leaffill = n (btree only)
• nonleaffill = n (btree only)
• blob_extend = n (btree only)
• newlocation = (locationname {, locationname})
• oldlocation = (locationname {, locationname})
• location = (locationname {, locationname})
• compression [= ([[NO]KEY] [,[NO|HI]DATA])] | NOCOMPRESSION
• [NO]PERSISTENCE
• unique_scope = ROW | STATEMENT
• page_size = n
• priority = cache_priority
• nopartition
• partition = (partitioning-scheme)
• concurrent_updates
• passphrase = encryption_passphrase
[new_passphrase = new encryption_passphrase]