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

What are constraints in microsoft sql server?

553


what is a sub-report?

96


What is difference between aggregate and analytic function?

476


How to join two tables in a single query in ms sql server?

532


Define Unique Key?

588






How to convert numeric expression data types using the cast() function?

541


What are data regions?

90


What is the difference between mysql and sql server?

467


What is pivot and unpivot?

632


How real and float literal values are rounded?

578


What is an index. What are the types?

580


What is nolock?

549


How do I get to sql server configuration manager?

507


What is a non equi join?

536


Will the writetext statement activate a trigger?

563