How to add or delete a column (Enterprise Manager)
To add or delete 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.
- To delete an existing column, right-click the column name, and then click Delete Column.
- To add a new column, select the existing column name that the new column should be inserted immediately before, right-click the column name, and then click Insert Column. Fill in the columns as appropriate. Each row represents one column in the table.
- To save the new table definition, right-click any column name, and then click Save Selection.
See Also
Adding and Deleting Columns
(c) 1988-98 Microsoft Corporation. All Rights Reserved.