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. You can:

·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


Access     Project | Settings | Database Datatypes

Add datatypes

Use the Database Datatypes dialog to add a new datatype to a DBMS product.



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


Click on this button to clear the data type fields on the dialog so that you can define another data type.




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.



Defined Datatypes for Databases

This panel lists the data types currently defined for the database, either system-supplied or user-defined.




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 Enterprise Architect models as Reference Data.

Learn more

Learning Center topics

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