Syntax to rename column name in table
|
SP_RENAME ‘TableName.[OldColumnName]’ , ‘[NewColumnName]’, ‘COLUMN’
|
Ex:
|
SP_RENAME ‘UserInformation.[Name]’ , ‘[ReName]’, ‘COLUMN’
|
Syntax to rename table name
|
SP_RENAME ‘[OldTableName]’ , ‘[NewTableName]’
|
Ex:
|
SP_RENAME ‘[Name]’ , ‘[ReName]’
|
