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: 2061 | 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

Bookmark It

< Previous : How to rename existing Table in Sql Server?

Next > : How to declare/define any variable in JavaScipt?

More Interview Questions by Rajesh_Kumar

Latest Interview Questions