The Columns tab of the entity Properties window enables you to change properties of the attributes in the entity.
The Columns list on the left side shows all the columns in the table, the search and filtering options are on top of the columns list. The properties of the selected column(s) are shown on the right.
Tip
- To select multiple columns, hold the Ctrl key and click on each of the columns you wish to select.
- To quickly select multiple contiguous columns, click on the first column, hold the Shift key and click on the last column.
The Search and Filtering section allows you to quickly find columns when dealing with large numbers of columns, as you type on the search field matching results start to populate the columns list. You can also use different filters to further narrow your results.
Icons | Description |
---|---|
Deploys a series of search options. Refer to Search and Filtering for information on the available options. | |
Deploys additional filtering options. |
Buttons | Description |
---|---|
Add | Click to Add a button. On the Add column dialog, enter the name of the column and click OK. |
Rename | Click to Rename the selected column. On the Rename dialog, enter a new name of the column and click OK. Note This button is disabled, if multiple columns are selected. |
Copy | Click to make a Copy of the selected column(s). On the Copy column dialog, enter the name of the column and click OK. When multiple columns are selected, the Copy column dialog is displayed for each selected column. |
Delete | Click to Delete the selected column(s). |
Move to top | Click to move the selected column(s) to the top of the list. |
Move up | Click to move the selected column(s) up one place in the list. |
Move down | Click to move the selected column(s) down one place in the list. |
Move to end | Click to move the selected column(s) to the end of the list. |
The available column properties varies depending on the current category settings. Refer to Attributes / General Settings and Constraint Settings for details.
Fields | Description |
---|---|
Created by | Indicates the source action that caused the column to be created. |
Label | Enter a label for the column. |
Data type | Select a data type from the drop-down list. |
Size | Enter the data type's size parameter. |
Scale | Enter the data type's scale parameter. |
Charset | Enter the column's character set. |
Column type | Select the attribute types assigned to the column from the drop-down list. |
Rating | Select a rating for the column from the drop-down list. |
Nullable |
|
Unique |
|
Primary key |
|
Auto increment |
|
Default value | Enter the default value for the column. |
Sequence | Enter the name of the sequence assigned to this column if it exists. Note This field is only displayed when the table's target location has Oracle, Netezza, PostgreSQL, Ingres, Informix, H2, HSQL or DB2 as the RDBMS. Refer to Target Location Descriptors for details. |
Comment | Enter a comment on the column. |
Hidden |
|
Subjects | The repository documentation subjects can be configured. |
Documentation | The documentation for custom subjects on the column. Refer to Documentation Settings for details. |