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:
- MS Access 97, 2000, 2003
- Access 2007
- Oracle 9i, 10g and 11g
- SQL Server 2000, 2005 and 2008
- Sybase Adaptive Server Anywhere (Sybase ASA)
- Sybase Adaptive Server Enterprise (Sybase ASE).
To set the database type, follow the steps below:
- Double-click on the table element in a diagram to open the Properties dialog.
- Select the General tab.
- In the Database field, click on the drop-down arrow and select the database type.
- Click on the Apply button to save changes.