Creating Offline Column Definitions

Create or edit columns in an offline table definition. You can do this:

To create or edit a column definition using the dialog:

In the navigator, expand the workspace, project, schema, and Tables, and select Edit from the context menu.

or

On the database diagram, double-click the table definition, or select Pr operties from the table definition context menu.

Select Column Information to display information about existing column definitions.
Click to add a new column, and enter properties for it. For information about how to fill these in values, click Help in the dialog.
Click OK to create or update the column.

Alternatively, you can edit column definitions directly on the diagram.

To create or edit a column definition on the diagram:

In the column compartment (the second compartment on a modeled table), select either the column definition you want to edit or a blank line for a new column. Click once to select the right place, then click again to enter edit mode. You may need to resize the table definition to see the column or to add a new column.
To edit an existing column, type your changes into the selected line.
To add a new column, enter the new column definition following this format
<COLUMN_NAME> : <TYPE>(nn)
where <COLUMN_NAME> is the name of the new column, and <TYPE>(nn) is the column type, followed optionally by the number of characters.
When you press Enter or click elsewhere on the diagram the column is updated or created.