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 are the different types of replication you can set up in sql server?

1088

What is schemabinding a view?

969

What do you understand by a stored procedure?

1150

Give me any three differences between Truncate and Delete.

1155

What is xdr?

1041

What is self contained multi valued query?

1074

tell me what is blocking and how would you troubleshoot it? : Sql server database administration

941

What is log cache in sql server?

1097

Can another user execute your local temporary stored procedures?

1023

What is buffer cash in sql server?

1203

What do you mean by tablesample?

1124

How to enter comments in transact-sql statements?

986

What is SQL Server?

1269

Explain about local stored procedure?

1028

What is the difference between resultset and resultsetmetadata?

1030