How to rename a column (Enterprise Manager)
To rename a column
Expand a server group; then expand a server.
Expand Databases, expand the database in which the table belongs, and then click Tables.
In the details pane, right-click the table, and then click
Design Table
.
In the cell that shows the column name you want to change, type a new column name.
Make sure that it does not duplicate another column name in the same table.
See Also
How to rename a column using a database diagram
Modifying Column Properties
(c) 1988-98 Microsoft Corporation. All Rights Reserved.