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




See also


Click on the drop-down button and select the required database type from the list.


Click the Apply button to save any pending changes.


Click the OK button to save any pending changes and close the screen.

Learn more

Learning Center topics

  • Alt+F1 | Enterprise Architect | Database Engineering | Physical Data Model | DBMS Datatypes