How to rename a Table Column in Sql Server?

Posted by vishalneeraj-24503 on 1/26/2014 | Category: Sql Server Interview questions | Views: 2553 | Points: 40

Post |

Interview FAQs |

Exclusive Questions |

Interview Home

Answer:

With the help of sp_rename system function,we can rename table,column,stored procedure.

Syntax:-
EXEC sp_rename 'Table1.column_name1', 'column_name2','COLUMN';

Asked In: Many Interviews | Alert Moderator

Bookmark It

< Previous : How to rename employee_contact column to employee_ ...

Next > : What is the use of CausesValidation property in As ...

Comments or Responses

Posted by: Sheonarayan on: 1/27/2014 | Points: 10

Nice and amazing script.

More Interview Questions by vishalneeraj-24503

What is the use of CausesValidation property in Asp.Net?
What will happen,when we execute below query? Select Substring(' ...
What will be the output of below Substring function? Select Substri ...
Give an example of SubString function?
What do we mean by Substring function in Sql Server?
How to rename sp_get_users_list to sp_get_all_list_of_users.
What is the use of sp_rename in Sql Server?
What are the type-conversion methods available in Dot Net?

Latest Interview Questions

What will happen,if we run below query in query analizer? Select Mo ...
What is the return type of Month in-built sql server function?
What will be output of below query? Select Month('01/23/2014 ...
What is the use of Month in-built Sql-Server function?
How many joins are there in Sql-Server?
What are the types of Cursors?
What considerations must be there when working with Cursors?
How to remove leading space from below string? string name = " ...
More ...