Physical Modeling › Columns › Add a Column to a Table Using the Table Column Editor

Add a Column to a Table Using the Table Column Editor

After you add a new table to a physical model, you need to add columns to the table. You can use the Table Column Editor to add columns to a table and define column properties.

To add a column to a table using the Table Column Editor

1. Right-click the table on the diagram to which you want to add a column and click Column Properties.

   The Table Column Editor opens.

2. Click New on the toolbar.

   A new column is displayed at the bottom of the column list in the Navigation Grid with default values.

3. Work with the following options in the Navigation Grid to assign values to the new column:

   Physical Name

   Displays the column name. You can change the column name in this field.

   Domain Parent

   Displays the parent domain associated with the column. You can change the parent domain or open the Domain Editor to create a new one using the drop-down.

   Physical Data Type

   Specifies the physical data type for the column. You can change the data type using the drop-down. The drop-down list contains the data types related to the current domain.

   Primary Key

   Specifies whether to include the column in the primary key. Select this check box if you want to include the selected column in the primary key. Clear this check box if you want a non-key column.

   Physical Only

   Specifies to have the column only appear in the physical model. You will not have a corresponding attribute.

4. Click the General tab and select a column null option using the Null Option drop-down.
5. Click Close.

   The Table Column Editor closes, and the column you added displays in the table on the diagram.

Note: You can click the up or down arrows in the toolbar to reposition the new column in the Navigation Grid, and also in the table on the diagram.

More information:

Table Column Editor