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, including the database type, for all supported DBMSs are set using the Properties dialog.

For MySQL and Oracle, some additional properties are defined using Tagged Values, such as the Table Owner and DBMS-specific options. Additional table properties for other DBMs are not yet supported.

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




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

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

Learn more: