How to Rename a column in a Table which is already exists?

 Posted by Rajesh_Kumar on 2/12/2014 | Category: Sql Server Interview questions | Views: 729 | Points: 40
Answer:

Use sp_rename Sql Server system stored procedure to rename any column exists in a Table.

Syntax Is:
sp_rename 'Table_Name.[Old_Column_Name]','New_Column_Name', 'Column'


Asked In: Many Interviews | Alert Moderator 

Comments or Responses

Login to post response