Rename tables, columns and constraints in Oracle
In more recent versions of Oracle you can rename
tables, columns and constraints.
Here are examples of the syntax:
ALTER TABLE table_name RENAME COLUMN column_name TO
new_column_name; (from Oracle9i Release 2)
ALTER TABLE table_name RENAME TO new_table_name;
ALTER TABLE table_name RENAME CONSTRAINT
constraint_name TO new_constraint_name;
ALTER INDEX index_name RENAME TO new_index_name;
It's also possible to drop a column:
ALTER TABLE table_name DROP COLUMN column_name;
|