sp_rename 'tablename.oldcolumnname','newcolumnname'

How can i change the column name.

Question Posted / durgaprasad

Answer Posted / durgaprasad

Is This Answer Correct ?

31 Yes

3 No

Please Help Members By Posting Answers For Below Questions

Tell me about builtinadministrator?

1046

What are the properties and different types of sub-queries?

1051

How to create new table with "create table" statements?

1193

How to find the version of sql server? : sql server database administration

1168

Explain the truncate command? : SQL Server Architecture

1234

Explain some stored procedure creating best practices or guidelines?

1003

How can you check the level of fragmentation on a table?

1087

what is a schema in sql server 2005? : Sql server database administration

1082

What is the purpose of linked server configuration in sql server?

1095

Explain features and concepts of analysis services?

1023

Do you know the policy based administration feature of sql server 2008?

1003

What is row-level compre?

1051

What are the rendering extensions of ssrs?

160

How to drop an existing schema in ms sql server?

1145

Explain what is the main purpose of having conversation group?

989