Creating a table using existing table

To create a table using an existing table definition:

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 on the table and select the Create Table Using option from the context menu.

    Create Table window is launched preloaded with the values of the selected table definition except the table name field.

  8. Click Create to create a table after modifying the required values.
    NOTE:

    • MXDM allows you to add, remove, or modify existing column definition in Create Table Using.

    • The selected table’s check constraints are not loaded in Create Table window.

    Create Table Using buttons

    Button

    Function

    Create

    Creates the table within a schema.

    Reload

    Restores the original table definition by performing a reset on all the tabs.

    Cancel

    Closes the Create Table wizard.