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:

·The list of data types that are available for defining columns, and
·Which dialect of DDL is generated

 

You can either set the DBMS as a default for all Database Tables, or within the Table Properties for each individual Table.

 

Add New Datatypes

Set the Database Type

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 Table Owner/Schema

Set MySQL options - To make use of Foreign Keys in MySQL, you must declare the Table type as InnoDB.

 

Set MySQL Options

Set Oracle options - To set additional Oracle Table properties, use the Table's Tagged Values.

 

Set Oracle Table Properties

 

Once the Database Table properties are defined, you are ready to add columns.

Learn more