Please note : This help page is not for the latest version of Enterprise Architect. The latest help can be found here.
Manage DBMS Settings
Using the Manage DBMS Options dialog, you can change the owner of a selected Table or all of the Tables in a Package. With the same dialog, you can add an index on the columns participating in a Foreign Key, provided that those columns are not already indexed.
Access Project Browser | Right-click on Package | Code Engineering | Reset DBMS Options
Change Table Owner
Field/Option/Button |
Action |
See also |
||||
|---|---|---|---|---|---|---|
Change Table Owner |
Select this checkbox.
|
|
||||
Current Owner |
Click on the drop-down arrow and select either:
|
|
||||
New Owner |
Type the name of the new Table owner.
|
|
||||
Process Child Packages |
If there are child Packages that might also require changing, select the checkbox.
|
|
||||
OK |
Click on this button to change the ownership of the selected Table, or all Tables in the selected Packages that have the specified current owner.
|
|
Create Indexes for Foreign Keys
Field/Button |
Action |
See also |
|---|---|---|
Create Indexes on Foreign Keys
|
Select this checkbox to create an index on all Foreign Keys (if one does not already exist). |
|
Process Child Packages |
If there are child Packages that also require changing, select the checkbox.
|
|
OK |
Click on this button to create the Foreign Key indexes.
|
|
Notes
| · | Existing data models might not contain indexes on Foreign Key columns |
Learn more
