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

  • Select the checkbox if you want the column to contain null values.
  • Clear the checkbox if you do not want the column to contain null values.

Unique

  • Select the checkbox if you want the column's values to be unique.
  • Clear the checkbox if you do not want the column's values to be unique.

Primary key

  • Select the checkbox to indicate whether the column is contained in the primary key for the table.
  • Clear the checkbox to indicate the column is not contained in the primary key for the table.

Auto increment

  • Select the checkbox to indicate whether the column's value is automatically generated, e.g. an IDENTITY column in SQL Server, a column with a SEQUENCE assigned in Oracle, or a column marked AUTO_INCREMENT in MySQL.
  • Clear the checkbox to indicate the column's value is not automatically generated.

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

  • Select the checkbox if you want the column to be hidden.
  • Clear the checkbox if you do not want to hide the column.

Subjects

The repository documentation subjects can be configured.

Documentation

The documentation for custom subjects on the column. Refer to Repository Documentation Settings for details.

  • No labels