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

Explain the benefits of user-defined functions?

1065

Does a sql server 2005 select statement require a from?

1025

What are the types of indexing?

1084

What is use of except clause? How does it differ from not in clause?

1021

How to include date and time values in sql statements?

1090

How can you control the amount of free space in your index pages?

1058

How to get all stored procedures in sql server?

1002

What are the joins in sql server? : sql server database administration

1014

What is the usage of sign function?

1115

What is sql injection? How to protect against sql injection attack?

1002

What is scrollable cursor?

1044

Is sql server difficult to learn?

924

Is INSTEAD OF trigger directly applicable to Table ?

1018

How to assign new column names in a view?

919

Define tempdb database?

1004