The RENAME COLUMN statement renames an existing column in an existing table in any schema (except the schema SYS).
To rename a column, you must be either the database owner or the table owner.
Other types of table alterations are possible; see ALTER TABLE statement for more information.
RENAME COLUMN tableName.simpleColumnName TO simpleColumnName
RENAME COLUMN EMPLOYEE.MANAGER TO SUPERVISOR
ALTER TABLE t ADD COLUMN c1_newtype NEWTYPE UPDATE t SET c1_newtype = c1 ALTER TABLE t DROP COLUMN c1 RENAME COLUMN t.c1_newtype TO c1