Database 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 data types that are supported by later versions of the DBMS and not yet included with Enterprise Architect
Remove any previously-added data types 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

Access

Ribbon

Configure > Reference Data > Settings > Database Datatypes

Manage Datatypes

You can transport these database data types between Enterprise Architect models using the 'Export Reference Data' and 'Import Reference Data' options.

Field/Button	Action	See also
Product Name	Click on the drop-down arrow and select an existing DBMS. Once a product is selected, all defined data types will be shown in the 'Defined Datatypes for Databases' list.
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 elements 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
New	Click on this button to clear the data type fields on the dialog so that you can define another data type.
Datatype	Type a name for the data type.
Size	Select the appropriate radio button for the required size and, if appropriate, specify the default and maximum values: None – for data types without a size component, such as INT Length – for data types that require a single size that defines the Length, such as VARCHAR(10) Precision & Scale – for data types that require two numeric values, such as DECIMAL(18,2)
Common Type	Click on the drop-down arrow and select the generic name of each data type. This is used when a Table's DBMS is changed.
Save	Click on the button to immediately save your data type to the repository (and add it to the 'Defined Datatypes for Databases' list).
Defined Datatypes for Databases	This panel lists the data types currently defined for the selected DBMS, either system-supplied or user-defined.
Delete	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

Learn more