How to rename a Table Column in Sql Server?

 Posted by vishalneeraj-24503 on 1/26/2014 | Category: Sql Server Interview questions | Views: 1382 | Points: 40
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 

Comments or Responses

Posted by: Sheonarayan on: 1/27/2014 | Points: 10
Nice and amazing script.

Login to post response