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
The Table Column Editor opens.
A new column is displayed at the bottom of the column list in the Navigation Grid with default values.
Displays the column name. You can change the column name in this field.
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.
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.
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.
Specifies to have the column only appear in the physical model. You will not have a corresponding attribute.
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.
Copyright © 2013 CA.
All rights reserved.
|
|