hi all sp_rename 'tablename.oldcolumnname','newcolumnname

How can i change the column name.

Question Posted / kinthada cnu

Answer Posted / kinthada cnu

hi all

sp_rename 'tablename.oldcolumnname','newcolumnname','column'

Is This Answer Correct ?

18 Yes

4 No

Please Help Members By Posting Answers For Below Questions

How to convert binary strings into integers in ms sql server?

983

What are the results of running this script?

880

Why we should not use triggers?

935

Explain important index characteristics?

999

How do you create type- insensitive operator?

1011

How to perform backup for certificates in sql server? : sql server security

1047

What is an indice?

999

Which table keeps information about stored procedures?

900

What is #temp and @table variable in SQL server?

1039

How to define output parameters in stored procedures?

979

How to Check if table exists in sql server?

1087

Explain what is the use of custom fields in report?

884

What is key attribute?

889

Do you know hot add cpu in sql server 2008?

913

What is cdc in sql server?

971