NonStop SQL/MP Reference Manual

NonStop SQL/MP Reference Manual—142115
A-30
ALTER TABLE Statement
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 the following security-related file attributes for table name:
For more detail, see the entry for a specific attribute.
attribute-spec
sets the following file attributes for table name:
For more detail, see the entry for a specific attribute.
SIMILARITY CHECK { ENABLE | DISABLE }
authorizes or prohibits similarity checks on table name.
Authorizing similarity checks (SIMILARITY CHECK ENABLE) on a table whose
version is older than 310 increases the version of the table (and the version of
objects that depend on the table) to 310. Such a table cannot be registered in an
older version catalog or accessed by older versions of NonStop SQL/MP software.
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