HOW TO RENAME A COLUMN NAME

Answer Posted / ram&saran

SP_RENAME '<table_name>.<old_column_name>','<new_column_name>'

Is This Answer Correct ?    1 Yes 2 No



Post New Answer       View All Answers


Please Help Members By Posting Answers For Below Questions

What is a performance monitor?

554


can an automatic recovery be initiated by a user? : Sql server administration

516


What are exact numeric data types in ms sql server?

508


Can you pass expressions to function parameters?

534


What are the difference between primary keys and foreign keys?

538






Differentiate between a having clause and a where clause.

519


What are different types of replication in sql server?

568


What happens if null values are involved in arithmetic operations?

582


Explain partitioned view?

588


What are the types of database schema? : sql server analysis services, ssas

598


Which are the third-party tools used in sql server and why would you use them?

491


How to perform backup for certificates in sql server? : sql server security

596


System requirements for sql server 2005 express edition?

567


You want to implement the one-to-one relationship while designing tables. How would you do it?

531


What type of Index will get created after executing the above statement?

640