Rename Column Name in table?

Sabarimahesh
Posted by Sabarimahesh under Sql Server category on | Points: 40 | Views : 1503
To Rename Ur ColumnName in a Table



Use this Syntax

EXEC sp_rename 
@objname = 'TableName.OldColumnName',
@newname = 'NewColumnName',
@objtype = 'COLUMN'

Comments or Responses

Login to post response