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

Model Database Table Columns

You create the columns of a database Table as stereotyped attributes of the Table element. The Database Builder encapsulates the Columns tab of the Columns and Constraints dialog, which provides the properties fields tailored to define a column.

Access     Tools | Database Builder | Click on Table | Right-click within Columns tab | Add new Column   (Ctrl+N)

A  database Table column definition with default properties is immediately added to the tab. You can click on each field and directly edit them to set the appropriate values.

If you want to delete a database Table column, right-click on the column name and select the Delete column <name> option, or click on the column name and press Ctrl+D. The column is immediately removed from the Table.

You can change the sequence of columns in the list, to define the order in which the columns appear in the generated DDL that defines your database schema.

If you have selected the PK checkbox for one or more columns, you can go on to define the Primary Key for the Table as a constraint.

Learn more