Oracle: rename a table column
September 10, 2008 22:56:11 Last update: September 10, 2008 22:56:11
Oracle Database lets you rename existing columns in a table.
Altering a table column can invalidate dependent objects. However, when you rename a column, the database updates associated data dictionary tables to ensure that function-based indexes and check constraints remain valid.
ALTER TABLE hr.admin_emp RENAME COLUMN comm TO commission;
Altering a table column can invalidate dependent objects. However, when you rename a column, the database updates associated data dictionary tables to ensure that function-based indexes and check constraints remain valid.
Easy email testing with http://www.ximailstop.com
