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

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

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