ALLBASE/SQL Reference Manual (36216-90216)

Chapter 10 305
SQL Statements A - D
ALTER TABLE
• When altering the type of an existing table, you can also specify the option to preserve
existing authority on the table or change the authority to the default for the new table
type. If you specify RESET AUTHORITY, the following changes are made to the table
authority:
• To indicate that a table is in no partition, the partition NONE can be specified.
• The
PartitionName specified must be one previously defined in a CREATE
PARTITION statement, must be the DEFAULT partition, or must be specified as
NONE.
• Changing the partition number of the table causes all future audit logging on the table
to use the new partition number. Past audit log records will not be altered to reflect a
change in a table's partition number; that is, the effect of this statement is not
retroactively applied to existing log records. If NONE was specified, there will be no
more audit logging done on this table (until another ALTER TABLE SET PARTITION
statement is issued on the table).
• When specifiying CLUSTERING ON CONSTRAINT, an error is returned if the table is
already clustered on a constraint or index or if the table is hashed.
• Adding a clustered constraint does not affect the physical placement of rows already in
the table.
• See syntax for the CREATE TABLE and CREATE INDEX statements for more information
on clustering.
Table 10-2. Changes to Table Authority in ALTER TABLE
Old Table Type New Table Type Changes to Authority
PRIVATE PUBLIC Grant ALL to PUBLIC
PUBLICROW Grant ALL to PUBLIC
PUBLICREAD Grant SELECT to PUBLIC
PUBLICREAD PUBLIC Grant ALL to PUBLIC
PUBLICROW Grant ALL to PUBLIC
PRIVATE Revoke ALL from PUBLIC
PUBLIC PUBLICROW No change
PUBLICREAD Revoke ALL from PUBLIC
Grant SELECT to PUBLIC
PRIVATE Revoke ALL from PUBLIC
PUBLICROW PUBLIC No change
PUBLICREAD Revoke ALL from PUBLIC
Grant SELECT to PUBLIC
PRIVATE Revoke ALL from PUBLIC