HOW TO RENAME A COLUMN NAME

Answer Posted / ravikv

SP_Rename 'dbo.table_name.column_name','new column_name'.

Is This Answer Correct ?    27 Yes 4 No



Post New Answer       View All Answers


Please Help Members By Posting Answers For Below Questions

Define master database?

746


What is the purpose of optimization?

736


Suppose we have a table "MyTable" containing 10 rows, what query should be executed to update the odd rows "Salary" as 9000?

761


How to fine-tune reports?

215


How can you insert null values in a column while inserting the data?

936


Explain what is row_number function?

773


What the class forname () does?

713


When does a workload on SQL Azure get throttled?

127


What does select 1 mean?

734


Write an sql query to find first weekday of the month?

677


Explain where clause?

747


Tell me about normalization in DBMS.

767


What options are there to delete rows on the publisher and not on the subscriber? : sql server replication

905


How to compose an inquiry to demonstrate the points of interest of an understudy from students table whose name begins with k?

864


What extended events?

779