Please note : This help page is not for the latest version of Enterprise Architect. The latest help can be found here.

Set the Database Type

The most important property to set for a table (after its name) is the database type. This defines the list of data types that are available for defining columns, and also declares which dialect of DDL is generated.

If this is not set, tables are created without a DBMS type and field typing cannot be allocated when creating new fields in the table.

You can set the database type to default to the required DBMS. However, if you have not set a default or want to change the value for specific tables, you can set the DBMS for each table individually.

Access    Table element | Element | Properties | General




See also


Click on the drop-down button and select the required database type from the list.





Save your changes.





Learn more

Add New Datatypes (to set default DBMS)

Learning Center topics

(Alt+F1) | Database Engineering | Physical Data Model | DBMS Datatypes