Access
To display or modify the integrity constraint generation parameters, click the Generate button in one of the following dialog boxes:
Logical entities (tab) of the LDM/PDM window,
Logical entities from the object search results in the Maintenance manager,
- Automatic generation (tab) when analyzing the correction validation for the environment,
after having checked the Generate integrity constraints box.
Tables are generated in several steps if the integrity constraint management option is selected.
Step 1: |
Deletion of integrity constraints referencing the selected entities. This step is required for subsequent entity generation. In general, a table referenced by a foreign key constraint cannot be destroyed. In SQL script generation mode, this step generates the SQL delete commands for the constraints defined in the Adelia repository. In the other modes, a command requesting the deletion of all keys referencing the table is generated. |
Step 2: |
Deletion of constraints defined for the selected entities. In SQL script generation mode, this step generates the SQL delete commands for the constraints defined in the Adelia repository. In the other modes, a command requesting the deletion of all keys referencing the table is generated. |
Step 3: |
Generation of the selected entities. Conventional operation, with or without data conservation. |
Step 4: |
Generation of constraints defined in the repository for the selected entities. |
Step 5: |
Generation of constraints defined in the repository referencing the selected entities. |
The choice of options to enable is determined by the desired result:
- to generate a new database, only steps 3 and 4 are required (creation of tables and constraints).
- to recreate a table independently of the others, select steps 1, 3, 4 and 5.
- you can use the steps independently to generate SQL management scripts.
Check boxes
Delete constraints referencing the tables
Checked |
Deletes the foreign key constraints referencing a unique key of one of the selected entities. |
Default value: checked.
Delete constraints
Checked |
Deletes the constraints defined for the selected entities. |
Default value: unchecked.
Generate tables
Checked |
Generates the selected entities. |
Default value: checked.
Generate constraints
Checked |
Generates the constraints defined in the repository for the selected entities. |
Default value: checked.
Generate constraints referencing the tables
Checked |
Generates the constraints defined in the repository for the selected entities. |
Default value: checked.
Buttons
Generate
Launches the chosen generation steps for the selected entities.
Cancel
Closes the dialog box and cancels the generation process.
Details
Displays a summary of operations to be performed according to the selected options.