Managing schemas and their properties

To display Schemas and their properties:

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.

    A list of catalogs for the selected system appears.

  4. Click and expand the contents of a Catalog.

    A list of schemas appears.

  5. Click and select a particular Schema.

    The following tabs related to the selected schema appear in the right pane:

    • Attributes

    • Tables

    • Views

    • Indexes

    • Procedures

    • SQL/MP Aliases

    • Sequences

    • DDL

    Figure 21 shows the schema properties.

    Schema properties