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

What is spatial and temporal data?

1047

What is the command used to check locks in microsoft sql server?

1092

What is server-level principal?

122

Explain the difference between cross join and full outer join?

1022

Define full outer join in sql server joins?

1044

What is the difference between a check constraint and a rule?

1345

How do I find the transaction log size in sql server?

1000

What is data source object?

1061

how to define testing of network layers? : Sql server database administration

1018

How to get the definition of a user defined function back?

1084

How display code or Text of Stored Procedure using Sql query in Sql Server ?

1190

can SSRS reports Cache results?

155

What is the recommended total size of your memory optimized tables?

1004

What is clustered primary key?

1078

How to create sub reports?

251