Dropping a table

To drop a table:

Procedure

  1. Log on to the MXDM.
  2. In the Navigation tree pane, click Database.

    MXDM displays a list of available systems in My Systems.

  3. Expand a selected system in the navigation tree.

    List of catalogs for the selected system appears.

  4. Click and expand the contents of a Catalog.

    The list of schemas appears.

  5. Expand a schema in the left pane.

    The Tables folder appears.

  6. Expand the Tables folder and select a table in the left pane.
  7. Right-click the table and select Drop Table from the context menu.

    Drop Table confirmation dialog appears.

  8. Select either of the following to drop the table:

    • Restrict—If the table is referenced by a view, trigger, or referential constraint of another table, or if the table has an active DDL lock, the specified table cannot be dropped. This is the default option.

    • Cascade—In this case, the table and all the views, triggers, referential constraints and inactive DDL locks are also dropped.

    NOTE:

    • To drop a table, you must own the schema which contains the table or be the super ID or object owner.

    • A table that has an active DDL lock cannot be dropped even if you select CASCADE. An active DDL lock is released when the utility locking the file completes.

  9. Click Yes to drop a table or No to discard the changes.