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.

ushalakshmi
Profile Answers by ushalakshmi Questions by ushalakshmi
Apr 16th, 2008
18
25864

Questions by ushalakshmi answers by ushalakshmi

SQL

Answer

Showing Answers 1 - 18 of 18 Answers

prakashb83
Profile Answers by prakashb83

Apr 17th, 2008

sp_rename 'oldtablename.cname', 'change columnname'

atdhdrolla
Profile Answers by atdhdrolla Questions by atdhdrolla

Jun 9th, 2008

Please try

Alter table <table name> change <Old column name > <new column name> varchar(10)

sweetytrivedi
Profile Answers by sweetytrivedi

Jun 17th, 2008

to change the column name can use the Rename command.

alter table <table_name>
rename column <old_column_name> to <new_column_name>;

mv_sivavardhan
Profile Answers by mv_sivavardhan

Aug 6th, 2008

sp_rename 'TableName.OldColumnName','NewColumnName' is correct

malapati
Profile Answers by 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,------);