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

What are the advantages of sql azure?

138

What is raiseerror? What is raiseerror?

1066

How do you troubleshoot errors in a SQL Server Agent Job?

1006

What are the 7 disadvantages to a manual system?

907

What is subquery explain with example?

1008

If a table does not have a unique index, can a cursor be opened on it?

872

Differentiate between truncate vs delete in mssql?

995

What are the two authentication modes in sql server?

1058

What is a group function explain with an example?

939

What is trigger and different types of Triggers?

1069

What is a fan-out query in SQL Azure?

121

What are the advantages of stored procedure in sql server?

833

What are the steps you should follow to start sql server in single-user mode?

846

Is it possible to have clustered index on separate drive from original table location?

906

How do I change my passwords (database, LDAP, and so on) without causing an outage?

1017