Rename Table Column in Sql Server by Query

Hi Techies,

Today i am going to rename table column using "sp_RENAME" system defined procedure in very simple way, please use bellow query.


EXEC sp_RENAME 'TableName.ColumnNameOld' , 'ColumnNameNew', 'COLUMN'


Thanks 
Rename Table Column in Sql Server by Query Rename Table Column in Sql Server by Query Reviewed by Ashwani on November 21, 2018 Rating: 5

No comments:

Powered by Blogger.