Reverse Engineering Options Tab

When you reverse engineer a database schema using script files or a data source, you can define rebuild options after reverse engineering.

The rebuild options automatically perform the following tasks after reverse engineering:

Option

Description

Automatically rebuild references when no reference is reversed

Rebuilds references (see Rebuilding References) when no references are reverse engineered. A reference is created between each column belonging to a primary key and a column, with identical name and data type, that does not belong to a primary or a foreign key in another table.

Automatically rebuild primary keys from unique indexes when tables have no key and only one unique index

Rebuilds primary keys (see Rebuilding Primary Keys) using unique indexes when tables have no key and only one unique index.

Automatically reverse tables referenced by selected tables

Reverse engineers the parents of the selected child tables in order to complement the definition of these child tables.

Create symbols

Creates a symbol for each reversed object in the diagram. If this option is not selected, reversed objects are visible only in the browser.

Where there are a large number of objects with complex interactions, PowerDesigner may create synonyms of objects to improve diagram readability. For example, if a table has a large number of references, PowerDesigner may create a synonym of the table in another location in the diagram to reduce the length required for references.

Apply code to name conversion to reversed objects

Applies the code to name conversion script specified in the model options (see Core Features Guide > Modeling with PowerDesigner > Objects > Naming Conventions).

File encoding

Specifies the default file encoding of the files to reverse engineer. Click the ellipsis to the right of the option to change the encoding (see Reverse Engineering Encoding Format).

Block/ Command terminator

Specify the end of block and end of command characters for the reversed script. By default, these value are defined in the DBMS definition file at Script\SQL\Syntax, and modifications made here are saved in the Registry for reuse in other models. To restore the DBMS value, click the Restore from DBMS tool.

Case sensitive database

Specifies that the database is case sensitive and enables the case sensitive option in the model.