Data Modeling Settings

Enterprise Architect provides data modeling settings that can be used to configure the way database systems are modeled in Enterprise Architect. These include the ability to define the data modeling language, which determines the way that connectors are displayed, and settings to configure the naming of Primary Keys, Foreign Keys and Indexes. The settings are global and will affect any Enterprise Architect repository.

Access

Ribbon

Start > View > Preferences > Source Code Engineering > Code Editors > DDL

DDL Editor

In this field you browse for the full execution file path and name of an external program that Enterprise Architect should use to open files that are created by its Generate DDL functionality. If you leave this field empty, Enterprise Architect uses the default code editor.

Default Database

In this field you select the DBMS that will be automatically assigned to database objects that are created outside a Data Model workspace (see the Create a Data Model from Model Pattern Help topic).

MySQL Storage

In this field you select the default storage engine to be assigned to MySQL Tables; from MySQL v 5.5 onwards the default value is InnoDB.

Learn more