How to add or delete a column (Enterprise Manager)

To add or delete 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. To delete an existing column, right-click the column name, and then click Delete Column.
  5. 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.
  6. 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.