How can i change the column name.

Answer Posted / desh deepak

sp_rename 'tablename.oldcolumnname',tablenamename.newcolumnn
ame

Is This Answer Correct ?    0 Yes 4 No



Post New Answer       View All Answers


Please Help Members By Posting Answers For Below Questions

What is difference between clustered index and non clustered index?

628


What options are available to audit login activity? : sql server security

635


What is the current pricing model of SQL Azure?

90


Can you please differentiate between a primary key and a unique key?

535


Explain what is cte (common table expression)?

626






Explain filtered indexes?

560


When is update_statistics command used?

587


What is self contained scalar sub query?

541


What is difference between temp table and cte?

539


Can we join two tables without primary key?

619


What is trigger in salesforce?

499


What are the dmvs?

575


What is the new security features added in sql server 2014? : sql server security

567


Is profiler the only tool that has the ability to audit and identify ddl events? : sql server security

582


How to connect to SQL Azure Database by using sqlcmd?

110