General Category (DBMS)

The General category is located directly beneath root, and contains high-level items that define the basic behavior of the DBMS.

Item

Description

EnableCheck

Specifies whether the generation of check parameters is authorized. The following settings are available. If this item is set to No, no variables linked to check parameters will be evaluated during generation and reverse-engineering.

EnableConstName

Specifies whether constraint names are supported by the DBMS. If this item is set to Yes, table and column constraint names are generated in addition to the constraints themselves.

EnableIntegrity

Specifies whether integrity constraints are supported by the DBMS. If this item is set to Yes, primary, alternate, and foreign key check boxes are available for database generation and modification

EnableMultiCheck

Specifies whether the generation of multiple check parameters for tables and columns is supported by the DBMS. If this item is set to Yes, multiple check parameters are generated, with the first constraint concatenating all the validation business rules, and additional constraints generated for each constraint business rules attached to the object. If this item is set to No, all business rules (validation and constraint) are concatenated into a single constraint expression.

SchemaStereotype Specifies the user stereotype to be used to indicate a schema (object owner).

SqlSupport

Specifies whether SQL syntax is supported by the DBMS. If this item is set to Yes, SQL syntax is supported and the SQL Preview is available.

UniqConstName

Specifies whether unique constraint names for objects are required by the DBMS. If this item is set to Yes, all constraint names (including index names) must be unique in the database. Otherwise constraint names must be unique only at the object level.

UserStereotype Specifies the user stereotype to be used to indicate a user (permissions grantee).