Deleting table columns

You are not permitted to delete primary key columns or columns in system tables.

About this task

Attention: Dropping a column requires a considerable amount of preliminary action to identify and remove any external dependencies on the column. This involves searching for any references to the column within triggers, procedures, views, restriction filters, probes rules files, and gateway mapping files. Be aware also that if you drop a column that has triggers, procedures, views, or restriction filters that depend on it, these dependent objects are also deleted, with a warning being written to the ObjectServer log file.

To delete a table column after confirming that no external dependencies exist:

Procedure

  1. From the Netcool/OMNIbus Administrator window, select the System menu button.
  2. Click Databases.
    The Databases, Tables and Columns pane opens.
  3. Select the table containing the column to delete.
  4. Click the Column Definitions tab.
  5. Select the column that you want to delete and click Drop Column in the toolbar. The column is removed from the table.