Defining key and update columns

Edit online

About this task

To update a table from a map, use the Database Interface Designer to specify the columns in a table to be used as key columns and to specifically specify the columns that will be updated.

To designate columns as key columns or columns to update:

Procedure

  1. In the Navigator, select the database containing the table for which you want to set update keys.
  2. From the Database menu, choose Set Update Keys.
    The Set Table Update Key Columns dialog appears.
  3. From the Table name list, select the table containing the columns to be updated.
    The columns in the table appear in the Columns list.
  4. To set a column as a key column, select it from the Columns list and click the right arrow button associated with the Key columns list.
    The selected column moves to the Key columns list.
  5. To designate a column as a column to update, select it from the Columns list and click the right arrow button associated with the Columns to update list.
    The selected column moves to the Columns to update list.
  6. To specify all non-key columns as Columns to update, click the all button associated with the Columns to update list.
    All of the columns in the Columns list move to the Columns to update list.
  7. To remove columns from either the Key columns list or the Columns to update list, select the column and click the associated "delete" button.
    The selected columns are moved back to the Columns list.

Results

A generated type tree with specified update keys is represented in the Navigator under Tables.