The Columns tab of the entity Properties window enables you to change properties of the attributes in the entity.
REPLACE WITH THIS IMAGE: Resources/Images/NewColumnProperties.png
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 |
---|
|
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 |
---|---|
REPLACE WITH THIS IMAGE: Resources/Images/searchOptions.png |
Deploys a series of search options. Refer to Search and Filtering for information on the available options. |
REPLACE WITH THIS IMAGE: Resources/Images/filterIcon.png |
Deploys additional filtering options. REPLACE WITH THIS IMAGE: Resources/Images/ColumnFilters.png |
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. |