• You must own any table containing columns you rename.

• The name of the new column must conform to the naming rules for columns (see Object Naming Rules on page 21).

• There must be no column already existing in the table having the same name.

• You cannot rename columns in a system catalog or in any table owned by the super user $ingres.

• If any views refer to the table column being renamed, the rename operation will fail with errors.

• Indexes, grants, comments, synonyms, sequences, are automatically transferred to the newly renamed column. For grants, the query text stored in the iiqrytext catalog is updated to reflect the new column name.

• The ALTER TABLE RENAME COLUMN operation can be rolled back.

• Any forms, join definitions, or reports that refer to the old table column name will be invalidated; these must be recreated and reloaded. Any copydb or unloaddb scripts generated before renaming columns can no longer be used for reload operations.