Prev | Next |
Manage DBMS Options
Using the 'Manage DBMS Options' dialog, you can quickly change the DBMS Type and/or Owner of an individual database object or several objects within an individual Package or Package hierarchy. You can also create bulk Foreign Key Indexes on all Foreign Keys that do not already have an index.
Access
Ribbon |
Code > Schema > DDL > Open the Database Builder or Specialize > Tools > Database Builder
Then: Right-click on the required database | Load | right-click on the root node | Manage DBMS Options |
Options
Option |
Action |
See also |
---|---|---|
Package |
Displays the name of the Package in the Project Browser that you are currently working on. If necessary, click on the button and select a different Package using the Navigator window (a version of the 'Find Package' dialog). |
|
Include Objects in Child Packages |
Select this checkbox to include all the database objects in all sub-Packages. Selecting or deselecting this control will immediately refresh the list of objects. |
|
List of Objects |
This list control will display the names of all objects in the current Package (or Package hierarchy) along with its allocated DBMS and owner. By default every object has its checkbox selected whenever the list is loaded or refreshed. |
|
All |
Click on this button to select all deselected checkboxes in the 'List of Objects'. |
|
None |
Click on this button to deselect all selected checkboxes in the 'List of Objects'. |
|
Change DBMS |
Select this checkbox if you want to change the assigned DBMS of objects in the Package. Provide values for the 'Current DBMS' and 'New DBMS' fields in order to continue. The 'Current DBMS' drop-down list includes the option '<All>', which changes several different DBMS values all to the new value. Note: When performing this function, the data types of all Table columns are automatically converted to the closest match for the selected DBMS; therefore, you should perform a manual review of the data types after running the process. |
|
Change Owner |
Select this checkbox if you want to change the Owner of the selected objects in the 'List of Objects'. Specify the current Owner in the 'Current Owner' field in order to continue. Leaving the 'New Owner' field blank will remove the Owner property of all selected objects. |
|
Create Indexes on Foreign Keys |
Select this checkbox to create an index on all Foreign Keys in the Package, where one does not already exist. |
DDL Name Templates |
OK |
Click on this button to start the update process. The button is disabled unless at least one object in the list and one of the update options are selected. |
Learn more