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). |