ALTER TABLE table_name RENAME COLUMN old_name to new

How can i change the column name.

Question Posted / kshirsagar sambhaji

Answer Posted / kshirsagar sambhaji

ALTER TABLE table_name
RENAME COLUMN old_name to new_name;

Is This Answer Correct ?

3 Yes

11 No

Please Help Members By Posting Answers For Below Questions

What is the use of keyword with encryption.

1014

Indexes are updated automatically is the full-text index also updated automatically?

1001

What are difference between Cluster index and Non-Cluster index?

1058

What is the difference between ‘having’ clause and a ‘where’ clause?

1027

What are the differences between char and varchar in ms sql server?

1043

How to convert numeric expression data types by assignment operations?

1052

What are sub reports?

201

Define full outer join in sql server joins?

954

How to use group functions in the select clause in ms sql server?

1034

What are recommended options to be used while using db mirroring? : sql server database administration

1124

Explain few examples of stored procedure over triggers?

1010

What is data set in report?

133

Can you roll back the ddl statement in a trigger?

944

What is tablesample?

1087

What are ddl triggers and types of ddl trigger?

1013