Setting Type System Options for the DDL Generator

Type system options control the database-specific generation of DDLs.

Type System Options

Type system options control the database-specific generation definition and manipulation of data structures of relational databases.

Type system options can be configured for all specializations of SQL objects beneath stereotypes. This means that type system options can also be used for DB design's stereotypes (e.g. tablespace as stereotype of database object group).

Each type system option is defined for a certain type system. The type system options can be configured in the same way as stereotype properties as a string, integer, enumeration etc.. This enables type system options to also always have a default value.

If the type system options are evaluated for an element, each type system option can always return a value, even if the type system option has not been explicitly set. This can present a problem for enumerations in particular, which is why the value "-" is used as the default value. As a result of the default value "-", the type system option is ignored during the evaluation of the type system options.

Setting Type System Options for the DDL Generation

Type system options are displayed in a separate tab in the Properties tool window.

Boolean options always have two possible values with "Yes" and "No". "Yes" means that the option is generated, and "No" means that it is not.

Enumeration options have at least three possible values for which the options are generated syntactically correctly. The default value "-" means that the options are not generated.

In the case of string and integer options, the input help list and its values provide help.

Note

Please note that although the visual appearance of the used default value for "Do not generate" does not differ from the minus sign in the drop-down list, the effect is, in fact, different. To use the default value, please always click on Restore Default. The minus sign in the drop-down list is not interpreted as the default value.

To configure the display and selection options of the type system options, you should preferably use the extension profiles (<base profile name> customization).