Configuration Guide

10.4 HotFix 2

Back Next

Navigating to the Column Editor

To configure columns for base objects and landing tables:

Start the Schema Manager.

Acquire a write lock.

Expand the schema tree for the object to which you want to add columns.

Select

Columns

The Schema Manager displays column definitions in the Properties pane.

The Column Editor displays a “lock” icon next to system columns if you select the

Show system columns

check box.

Command Buttons in the Column Editor

The Properties pane in the Column Editor contains the following command buttons:

Button	Name	Description
	Add Column	Adds new columns.
	Remove Column	Removes existing columns.
	Edit Column Description	Allows editing the description of the selected column.
	Move Up	Moves the selected column up in the display order.
	Move Down	Moves the selected column down in the display order.
	Import Schema	Allows adding new columns by importing column definitions from another table.
	Expand table columns view	Expands the table columns view.
	Restore table columns view	Restores the table columns view.
	Save	Saves changes to the column definitions.

Showing or Hiding System Columns

You can toggle the Show System Columns check box to show or hide system columns.

Expanding the Table Columns View

You can expand the properties pane to display all the column properties in a single pane. By default, the Schema Manager displays column definitions in a contracted view.

To show the expanded table columns view:

Click the

Expand table columns view

button.

The Schema Manager displays the expanded table columns view.

To show the default table columns view:

Click the

Restore table columns view

button.

The Schema Manager displays the default table columns view.

Configuring Columns in Tables

Download Guide