How to change the column name by using ALTER?

I Tried by giving.........................

ALTER table table name rename column to

column name was changed but it's not giving entire table with altered column name.

It's giving only the altered column.

Questions by ushalakshmi   answers by ushalakshmi

Showing Answers 1 - 6 of 6 Answers


  • Oct 8th, 2008

to change name of one column
alter  table  <table name>
rename column <old columnname> to <new columnname>;

if we want to change more than one column
 alter  table  <tablename>
 rename (old colname1,old colname2,-------) to (new colname1,new colname2,------);

  Was this answer useful?  Yes

Give your answer:

If you think the above answer is not correct, Please select a reason and add your answer below.


Related Answered Questions


Related Open Questions