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 Apply button to save any pending changes.

OK

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