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 status of services on passive node for failover cluster in sql server? : sql server database administration

1272

How to disable stored procedure sql server?

1609

What is apply operator in sql?

1015

How do you drop an index?

928

Why do we use functions?

918

What is difference between stored procedure and user defined function?

1114

what is database replicaion? What are the different types of replication you can set up in sql server? : Sql server database administration

991

What are the difference between data mart and data warehouse? : sql server analysis services, ssas

965

What are the advantages dts has over bcp?

1002

Explain ranking functions?

1054

How to drop an existing table?

1010

Explain about sql server login?

1092

What happens to a statement batch if there is a compilation error?

970

How to use "if ... Else if ... Else ..." Statement structures in ms sql server?

1084

What is a ddl statement?

920