Please note : This help page is not for the latest version of Enterprise Architect. The latest help can be found here.

Working with Table Properties

Once you have created a 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 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 properties are defined using Tagged Values, such as the Table Owner and DBMS-specific options. For other DBMSs, additional table properties are not yet supported.

Topics

Topic

Link

Set the Database type for a table - other than the table name, the most important property to set for a 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 tables, or within the Table Properties for each individual Table.

 

Add New Datatypes

Set the Database Type

Set the Table Owner  - Some relational databases enable you to assign a table to one of several owners within the database; Enterprise Architect enables you to model this using the Owner Tagged Value, so that in the generated DDL script the table name is prefixed by the owner name.

 

Set Table Owner/Schema

Example MySQL options - To make use of foreign keys in MySQL, you must declare the table type as InnoDB.

 

Set MySQL Options

Example Oracle options - To set additional Oracle table properties, use the table's Tagged Values.

 

Set Oracle Table Properties

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

Learn more