Register now or log in to join your professional community.
Using Management Studio, right-click the tablename, select Design from the pop-up menu, click the column you want to rename, type the desired column name then click save.
You can use sp_rename like this:
exec sp_rename 'tableName.OlColName', 'new column name', 'COLUMN'
