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

What is the simplest way to create a new database in ms sql server?

959

Explain external key management in sql server 2008

849

What do you mean by a Composite primary key?

1031

How to test values returned by a subquery with the in operator?

1135

How global temporary tables are represented and its scope?

907

What is multi-statement table-value user-defined function?

939

How does clustered and non clustered index work?

851

What is a cursor, index in sql?

1017

What is pivot and unpivot?

978

How to transfer an existing table from one schema to another schema in ms sql server?

927

Issues related in upgrading SQL Server 2000 to 2005 / 2008

1834

What language is sql server written in?

989

What is local temp table?

898

How do I get to sql server configuration manager?

953

What does REVERT do in SQL Server 2005?

919