Show TOC

Database Reverse Engineering Selection WindowLocate this document in the navigation structure

When you reverse engineer a database from a live database connection, you can choose to populate your PDM with a subset of the available objects by selecting them in the Database Reverse Engineering Selection window.



Click the subtabs to view the different types of objects. Certain object types have attributes, or options, that appear below the object lists. Options that are not available for the selected object type or DBMS are grayed. When you select tables containing triggers on the Table tab, the triggers are selected on the Trigger tab.

You can restrict database objects to reverse engineer in the top area of the window by selecting to filter by:

  • Qualifier - such as a database or a partition that contains one or more tables. For example, the DB2 DBMS authorizes the use of the qualifier field to select which databases are to be reverse engineered from a list.

  • Owner - normally the creator of a database object. To reverse engineer objects from multiple owners, select All users. Only users that have creation rights are reverse engineered.

    Note If the selected qualifier contains a large number of table owners, it may be faster to click the Select Qualifier and Owner tool and enter a qualifier and/or owner in the dialog box, as opening the Owner list may take a very long time.

You can save your selections for re-use by entering a selection name in the list at the bottom of the window and clicking the Save tool to the right of the list. Selections are saved with a .sel file extension, and are added to the list for subsequent use. You can change the folder in which the files are saved by clicking the folder tool to the right of the list.