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 Package context menu | Code Engineering | Reset DBMS Options

Change Table Owner

Field/Button

Action

See also

Change Table Owner

Select this checkbox.

 

 

Current Owner

Click on the drop-down arrow and select either:

The current owner to change, or
<All> to change the ownership of all tables in the package to the name you type in the New Owner field

 

 

New Owner

Type the name of the new table owner.

 

 

Process Child Packages

If there are child packages that 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 may not contain indexes on Foreign Key columns
 

Learn more