How can i change the column name.

Answer Posted / durgaprasad

sp_rename 'tablename.oldcolumnname','newcolumnname'

Is This Answer Correct ?    31 Yes 3 No



Post New Answer       View All Answers


Please Help Members By Posting Answers For Below Questions

Why use triggers?

577


What is the boxing and unboxing concept in .net?

550


What are the different types of columns types constraints in the sql server?

529


Is there any difference between primary key and unique with the not null condition?

529


What is an inner join?

530






What is use of @@ spid in sql server?

684


What are the differences between having and where clause.

558


What happens if null values are involved in comparison operations?

547


Why SQL Agent is used?

602


How to create a simple user defined function in ms sql server?

547


In one interview...interviewer ask me question pleas tell me sql server architecture.. can any body tell me the sql server architecture with digram

1515


Explain the relational database management system (rdbms)?

528


What is the order by used for?

625


Explain DBCC?

572


Tell me what is difference between view and materialized view?

525