Rules and Restrictions on Renaming Columns
Be aware of the following guidelines and restrictions when renaming columns:
• 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).
• 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.