Once you have created your table, you can set its properties. Most table properties can be set from the Properties dialog, as described below. Some properties though must be entered as Tagged Values as described elsewhere, i.e. setting the value of the Table Owner and, for MySQL 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
• MySQL
• Oracle 9i, 10g and 11g
• PostgreSQL
• SQL Server 2000 and 2005
• 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 OK 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.