sp_rename 'tablename.oldcolumnname',tablenamename.newcolumnn ame

How can i change the column name.

Question Posted / desh deepak

Answer Posted / desh deepak

sp_rename 'tablename.oldcolumnname',tablenamename.newcolumnn
ame

Is This Answer Correct ?

0 Yes

4 No

Please Help Members By Posting Answers For Below Questions

How to get a list of columns using the "sys.columns" view in ms sql server?

1010

What are the differences between ms sql server & oracle?

1116

What are the hotfixes and patches in sql server?

1066

Explain sql server authentication modes?

1189

When would you use sql joins?

1030

Explain nested join?

1036

What is unpivot?

1077

How is table type constraint applied to a table?

1030

Explain about SQLOS?

1060

What are the types of subquery?

1097

What is the exact numeric data type in sql?

1057

What is a subquery in a select query statement in ms sql server?

1189

What is the difference between varchar and varchar(max) datatypes?

1138

Explain go command in sql server?

1090

How does a profiler work?

995