Please note : This help page is not for the latest version of Enterprise Architect. The latest help can be found here.
| Prev | Next |
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
Select a Table in the Project Browser or on a diagram then, using any of the methods outlined here, open the Table's 'Properties' dialog, display the 'General' tab, then display the 'Main' child tab.
|
Ribbon |
Design > Element > Properties > Properties Dialog > General > Main |
|
Context Menu |
Right-click on the Table element | Properties | Special Action | General | Main |
|
Keyboard Shortcuts |
| General | Main |
|
Other |
Double-click on the Table element |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 on the to save any pending changes. |
|
|
OK |
Click on the to save any pending changes and close the screen. |