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 are the basic functions for master, msdb, model, tempdb and resource system databases? : sql server database administration

656


you have a table with close to 100 million records recently, a huge amount of this data was updated now, various queries against this table have slowed down considerably what is the quickest option to remedy the situation? : Sql server administration

620


how to determine the service pack currently installed on sql server? : Sql server database administration

649


Can you type more than one query in the query editor screen at the same time?

676


What are difference between Cluster index and Non-Cluster index?

683






When would you use a before or after trigger?

570


What is a result set object returned by odbc_exec()?

626


Why do you want to join software field as you have done your BE in Electronics?

1786


What is an entity-relationship diagram (erd)?

678


What are the diifferences between the ms sql server vs mysql?

756


What happens when converting big values to integers?

664


What is GUID in sql server?

738


How to create new table with "create table" statements?

644


can a database be shrunk to 0 bytes, if not, why? : Sql server administration

702


What is the filtered index?

674