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 - 5 of 5 Answers

malapati

  • 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.

Answer Question

Click here to Login / Register your free account


 
Send   Reset

 

Related Answered Questions

 

Related Open Questions