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 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:
Step |
Action |
See Also |
---|---|---|
1 |
Select the Database Datatypes menu option The Database Datatypes screen displays |
|
2 |
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 |
|
3 |
In the Datatype field, type a name for the data type |
|
4 |
Select the appropriate Size radio button and, if appropriate, specify the default and maximum values |
|
5 |
In the Common Type field, click on the drop-down arrow and select a common type to which your data type applies |
|
6 |
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:
- Add MySQL Data Types
- Customize Oracle Data Types
- Export Data Types as Reference Data
- Import Data Types as Reference Data