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 types of joins in sql?

1171

What is the main purpose of having conversation group?

948

What is tempdb in sql server?

1029

Explain primary key?

1006

What is auditing in sql server?

967

Can sql server 2016 run on windows 7?

965

What is difference between global temporary tables and local temporary tables?

1281

How can you set the threshold at which sql server will generate keysets asynchronously?

1052

A trigger can reference objects outside the current database? State true or false.

1060

Explain about SQL server 2005?

1026

Tell me what is sql profiler?

1083

Where are sql server usernames and passwords stored in the sql server?

1174

what is a self join? : Sql server database administration

1123

What is standby servers? Explain types of standby servers.

1057

What are clustered and non-clustered index?

1050