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

Add New Datatypes

Using Enterprise Architect's Database Datatypes dialog, you can add to the set of data types that are available for a particular DBMS.

Access    Settings | Database Datatypes

Use to

Identify the DBMS in use and, if required, set this as the model default
Include any new datatypes that are supported by later versions of the DBMS and not yet included with Enterprise Architect
Remove any datatypes that are no longer relevant
Add a new DBMS product and its built-in data types if, for example, you want to create a physical data model for a DBMS product that is not yet supported natively by Enterprise Architect
Change the DBMS in use and begin to map the datatypes to the new DBMS


Use the Database Datatypes dialog to add a new datatype to a DBMS product, as described below:



See also

Product Name

Click on the drop-down arrow and select an existing DBMS.



Add Product

If your DBMS is not listed, click on this button to add it.

An Input prompt displays, in which you type the DBMS name; click on the OK button to add the name to the drop-down list.



Set as Default

Select the checkbox to set the selected DBMS as the default for your database engineering and modeling.

Once you set the default database, when you create any new Table element the Database type is automatically pre-set to this default.

You can also set the default database type through the Code Generation Toolbar.


Physical Data Model


Code Generation Toolbar


Type a name for the data type.




Select the appropriate radio button and, if appropriate, specify the default and maximum values.



Common Type

Click on the drop-down arrow and select a common type to which your data type applies.




Click on the button to create your data type and add it to the Defined Datatypes for Databases list.




Select a data type in the Defined Datatypes for Databases list and click on this button to remove the data type.



Datatype Map

If you have changed the DBMS or technology for which you have defined the data types from or to an unsupported DBMS type, click on this button to define how to automatically remap the data types to your new DBMS or technology.


Map Data Types Between DBMS Products

You can transport these data types between models as Enterprise Architect Reference Data.

Learn more

Learning Center topics

(Alt+F1) | Database Engineering | Physical Data Model | Data Type Map