By using this site, you agree to our updated Privacy Policy and our Terms of Use. Manage your Cookies Settings.
440,289 Members | 3,049 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 440,289 IT Pros & Developers. It's quick & easy.

how to change the column name to an already existing table

P: 1
friends please let me know how to change the name of the column to an already existing table
Oct 30 '08 #1
Share this Question
Share on Google+
1 Reply


100+
P: 127
(From Oracle 9i release 2)
ALTER TABLE table_name
RENAME COLUMN old_name to new_name;

You can find more info on this at:

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

Pilgrim
Oct 30 '08 #2

Post your reply

Sign in to post your reply or Sign up for a free account.