how to change the column name to an already existing table

**Pilgrim333** · Oct 30 '08, 06:32 PM

(From Oracle 9i release 2)
ALTER TABLE table_name
RENAME COLUMN old_name to new_name;

You can find more info on this at:

SQL: ALTER TABLE Statement

http://www.techonthenet.com/sql/tables/alter_table.php

This SQL tutorial explains how to use the SQL ALTER TABLE statement to add a column, modify a column, drop a column, rename a column or rename a table (with lots of clear, concise examples). It is used to add, modify, or drop/delete columns in a table.

Pilgrim

how to change the column name to an already existing table

how to change the column name to an already existing table

Comment