Naming is important and when you find a more precise one, you not only should update your code but your database as well. SQL Server has the function sp_rename to rename objects in your database.
To rename the column OldName to NewName in your table dbo.MyTable, you can use this command:
|
1 |
EXEC sp_rename 'dbo.MyTable.OldName', 'NewName', 'COLUMN'; |
Attention: Make sure that you ONLY use the new column name in the second parameter and do not also specify Schema.TableName. Otherwise you will rename the column to something like ‘dbo.MyTable.dbo.MyTable.NewName’.
This little trick will help you to keep your database schema up to date.