How to rename a column (Enterprise Manager)

To rename a column

  1. Expand a server group; then expand a server.
  2. Expand Databases, expand the database in which the table belongs, and then click Tables.
  3. In the details pane, right-click the table, and then click Design Table.
  4. 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.