Please note : This help page is not for the latest version of Enterprise Architect. The latest help can be found here.
Working with Database Table Properties
Once you have created a Database Table, you must set its properties to define database-specific information that can be used to generate the schema in DDL. Table properties are set using the Properties dialog.
It is recommended that you set the DBMS you are using as a default, to automatically apply that DBMS definition to all Database Tables you create. However, if you do not set a default, or want to change the value for specific Tables for any reason, you can also identify the DBMS on the Table Properties dialog for each Table.
For MySQL and Oracle, some additional DBMS-specific options are defined using Tagged Values. For other DBMSs, additional Table properties are not yet supported.
Tasks
Task |
Link |
||||
|---|---|---|---|---|---|
Set the Database type for a Table - other than the Table name, the most important property to set for a Database Table is the database type, which defines:
You can either set the DBMS as a default for all Database Tables, or within the Table Properties for each individual Table.
|
|||||
Set the Database Table Owner - For some relational databases you can assign a Table to one of several owners within the database; in Enterprise Architect you define this on the Table Details tab, so that in the generated DDL script the Table name is prefixed by the owner name.
|
|||||
Set MySQL options - To make use of Foreign Keys in MySQL, you must declare the Table type as InnoDB.
|
|||||
Set Oracle options - To set additional Oracle Table properties, use the Table's Tagged Values.
|
|
Once the Database Table properties are defined, you are ready to add columns.
Learn more
