Renaming a table

Renaming a table changes the logical name of the table within the schema.

To rename 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 Rename Table from the context menu.

    Rename Table dialog appears.

  8. Enter the new ANSI name of the table.
  9. Select Cascade to automatically rename the system generated ANSI names of indexes and constraints associated with the table.
  10. Click OK to rename the table, else click Cancel to discard the changes.
    NOTE:

    Renaming a table changes the text of referencing views, RI constraints, and triggers to reference the new name.