- 1). Open the SQL Server Enterprise Manager utility. Click the Windows "Start" button and select "Programs > Microsoft SQL Server > SQL Server Enterprise Manager."
- 2). Open the SQL Query Analyzer. Click "Tools" in the menu at the top of the Enterprise Manager screen, and then select "SQL Query Analyzer."
- 3). Change your column name. Use the command provided below as a model for changing the column name in an SQL Server database:
USE DatabaseName
GO
sp_RENAME 'TableName.[CurrentColumnName]' , '[NewColumnName]', 'COLUMN'
GO
Substitute your database name on line 1. Provide the name of the table containing the column you want to change on line 3, along with the current name of that column within the brackets that immediately follow it. Supply the new column name within the next set of brackets. Run the query to finalize the column name change.
SHARE
