SP_RENAME '<table_name>.<old_column

HOW TO RENAME A COLUMN NAME

Question Posted / ram&saran

Answer Posted / ram&saran

SP_RENAME '<table_name>.<old_column_name>','<new_column_name>'

Is This Answer Correct ?

1 Yes

2 No

Please Help Members By Posting Answers For Below Questions

What is a recursive stored procedure in sql server?

1117

what data regions are and what are the different data regions?

136

Can you move the resources after pausing the node? : sql server database administration

1051

How can you insert values in multiple rows using one Insert statement?

1058

What is the difference between row_number and dense_rank?

845

Explain alternate key, candidate key and composite key in sql server?

876

Can a table have 2 primary keys?

949

Explain in brief about Microsoft SQL server?

1036

How to create database with physical files specified in ms sql server?

967

What is the difference between varchar and nvarchar?

913

What is spatial and temporal data?

946

You are doing log shipping due to some reasons it is failing. How you will proceed from there

2039

why would you call update statistics? : Sql server database administration

1039

What is BCP? When does it used in sql server 2012?

1019

What is change tracking in sql server?

958