Renaming a table
Renaming a table changes the logical name of the table within the schema.
To rename a table:
Procedure
- Log on to the MXDM.
-
In the Navigation tree pane, click
Database.
MXDM displays a list of available systems in My Systems.
-
Expand a selected system in the navigation tree.
List of catalogs for the selected system appears.
-
Click and expand the contents of a Catalog.
The list of schemas appears.
-
Expand a schema in the left pane.
The Tables folder appears.
- Expand the Tables folder and select a table in the left pane.
-
Right-click the table and select
Rename Table from the context menu.
Rename Table dialog appears.
- Enter the new ANSI name of the table.
- Select Cascade to automatically rename the system generated ANSI names of indexes and constraints associated with the table.
-
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.