Set the Database Type

The most important property to set for a Database 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, Database 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 Database Table individually.

Access    Table element | Element | Properties > General > Main




See also


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





Click on one of these buttons to save your changes.





Learn more

·Add New Datatypes (to set default DBMS)

Learning Center topics

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