ALTER TABLE table_name RENAME COLUMN old_name to new

How can i change the column name.

Question Posted / ramesh5782

Answer Posted / ramesh5782

ALTER TABLE table_name
RENAME COLUMN old_name to new_name;

Is This Answer Correct ?

22 Yes

17 No

Please Help Members By Posting Answers For Below Questions

Difference between LEN() and DATALENGTH() in sql server ?

1170

Issues related in upgrading SQL Server 2000 to 2005 / 2008

1939

What are the basic functions for master, msdb, model, tempdb and resource databases? : SQL Server Architecture

1056

How to define output parameters in stored procedures?

1081

Do you know what are acid properties?

1122

query processing

2217

What is the most common type of join?

1038

Define inner join in sql server joins?

1125

What are the purposes of floor and sign functions?

1018

What is Cross Join and in which scenario do we use Cross Join?

1058

What keyword you will use to get schema appended to the result set of a ‘for xml’ query?

1060

How to sort the query output with order by clauses in ms sql server?

1067

What are the different types of triggers in SQL SERVER?

1185

What do you understand by recursive stored procedures?

1043

What is right outer join in sql server joins?

1216