General Category

The General category is located directly beneath root, and contains the following items:

Item

Description

EnableCheck

Specifies whether the generation of check parameters is authorized. The following settings are available:

  • Yes - Check parameters generated

  • No - All variables linked to Check parameters will not be evaluated during generation and reverse

Enable Constname

Specifies whether constraint names are used during generation. The following settings are available:

  • Yes - Constraint names are used during generation

  • No - Constraint names are not used

EnableIntegrity

Specifies whether there are integrity constraints in the DBMS. The following settings are available:

  • Yes - Primary, alternate, and foreign key check boxes are available for database generation and modification

  • No - Primary, alternate, and foreign key check boxes are not available

EnableMulti Check

Specifies whether the generation of multiple check parameters for tables and columns is authorized. The following settings are available:

  • Yes - Multiple check parameters are generated. The first constraint in the script corresponds to the concatenation of all validation business rules, the other constraints correspond to each constraint business rules attached to an object

  • No - All business rules (validation and constraint) are concatenated into a single constraint expression

SqlSupport

Specifies whether SQL syntax is allowed. The following settings are available:

  • Yes - SQL syntax allowed and SQL Preview available

  • No - SQL syntax not allowed. SQL Preview is not available

UniqConst Name

Specifies whether unique constraint names for objects are authorized . The following settings are available:

  • Yes - All constraint names (including index names) must be unique in the database

  • No - Constraint names must be unique for an object

Check model takes this item into account in constraint name checking.