SQL/MP Reference Manual

HP NonStop SQL/MP Reference Manual—523352-013
A-32
ALTER TABLE Statement
name cannot specify a catalog table other than CATALOGS, PROGRAMS,
TRANSIDS, or USAGES. (You can use security-spec to change security
attributes for these tables, but you cannot use any other ALTER TABLE clause with
any catalog table.)
RENAME new-name
changes the file and subvolume portions of the name of a table (including all its
partitions) to those in the Guardian name (or equivalent DEFINE) new-name,
updating all catalog references to reflect the change.
name and new-name must have the same node and volume name when
expanded.
security-spec
sets these security-related file attributes for table name:
For more information, see the entry for a specific attribute.
attribute-spec
sets these file attributes for table name:
For more information, see the entry for a specific attribute.
SIMILARITY CHECK { ENABLE | DISABLE }
authorizes or prohibits similarity checks on table name.
CLEARONPURGE Controls disk erasure when table is dropped
NOPURGEUNTIL Sets date after which drop is allowed
OWNER Specifies owner
SECURE Sets Guardian security string
ALLOCATE Controls amount of disk space allocated
AUDIT Controls TMF auditing. Default is AUDIT
AUDITCOMPRESS Controls whether unchanged columns are included in audit
records
BUFFERED Turns buffering on or off
LOCKLENGTH Sets byte count in key for generic locks
MAXEXTENTS Sets maximum extents
RESETBROKEN Resets BROKEN flag
SERIALWRITES Specifies serial or parallel writes
TABLECODE Sets tablecode
VERIFIEDWRITES Controls verification of writes to disk