SQL Language Guide > SQL Language Guide > SQL Statements > ALTER TABLE > Rules and Restrictions on Renaming Columns
Was this helpful?
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 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.
Last modified date: 03/21/2024