Products Downloads


French version


 

Access

To display or modify the integrity constraint generation parameters, click the Generate button in one of the following dialog boxes:

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.

 

 

 

↑ Top of page

  • Aucune étiquette