Working with Tables


Once you have created your table, you can set its properties. Most table properties can be set from the Properties dialog, as described below. However, some properties must be entered as Tagged Values as described for setting the value of the Table Owner and, for MySQL and Oracle databases, setting the table options.

Set the Database Type

The most important property to set for a table (after its name) is the database type. This defines the list of datatypes that are available for defining columns, and also declares which dialect of DDL is generated. Enterprise Architect supports the following databases:

  • DB2
  • Informix
  • Ingres
  • InterBase
  • MS Access 97, 2000, 2003
  • Access 2007
  • MySQL
  • Oracle 9i, 10g and 11g
  • PostgreSQL
  • SQL Server 2000, 2005 and 2008
  • SQLServer7
  • Sybase Adaptive Server Anywhere (Sybase ASA)
  • Sybase Adaptive Server Enterprise (Sybase ASE).

To set the database type, follow the steps below:

  1. Double-click on the table element in a diagram to open the Properties dialog.
  2. Select the General tab.
  3. In the Database field, click on the drop-down arrow and select the database type.
  4. Click on the Apply button to save changes.

By clicking on the Table Detail tab on this dialog, you can access the Columns dialog or Operations dialog, or you can Generate DDL for this table.