Please note : This help page is not for the latest version of Enterprise Architect. The latest help can be found here.
Set the Database Type
The most important property to set for a Database Table (after its name) is the database type or DBMS. The DBMS value selected will control how Enterprise Architect will determine:
- How the Table name will be shown (with or without an Owner)
- What set of validation rules will be applied while database modeling
- The data types that are available when creating columns,
- What set of DDL templates will be used in DDL Generation
Access Table element | Element | Properties > General > Main
Options
Field/Button |
Action |
See also |
---|---|---|
Database |
Click on the drop-down button and select the required database type from the list. |
|
Apply |
Click the to save any pending changes. |
|
OK |
Click the to save any pending changes and close the screen. |
Learn more
- Create a Database Table
- Create Database Table Columns
- Working with Database Table Properties
- Database Datatypes (to set default DBMS)
- Code Generation Toolbar
Learning Center topics
- Alt+F1 | Enterprise Architect | Database Engineering | Physical Data Model | DBMS Datatypes