Add New Datatypes

Using Enterprise Architect's Database Datatypes screen, you can add to the set of data types that are available  for a particular DBMS. This enables you to include any new datatypes that are supported by later versions of the DBMS and not yet included with Enterprise Architect.

You can also add an entire DBMS product and its built-in data types. This is helpful if you want to create a physical data model for a DBMS product that is not yet supported natively by Enterprise Architect.

Access:    Settings | Database Datatypes

How To:

To add a new datatype to a DBMS product, follow the steps below:



See Also


Select the Database Datatypes menu option

The Database Datatypes screen displays



In the Product Name field click on the drop-down arrow and select an existing DBMS

If your DBMS is not listed, you can click the Add Product button to add it



In the Datatype field, type a name for the data type



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



In the Common Type field, click on the drop-down arrow and select a common type  to which your data type applies



Click on the Save button to create your data type


You can transport these data types between models using Enterprise Architect's Reference Data

Learn more: