| Note: | This task applies only to an Enterprise Database Server database that is mapped to SQL. |
Perform the following steps to modify occurring items:
-
From the tree view, expand the server containing the database you want to modify.
-
Expand the database you want to modify, and expand the Tables node representing each data set in the database.
-
Expand the Occurring Items node to display each occurring item or group.
An occurring item or an occurring group appears as a separate, normalized table to SQL.
-
From the tree view, select the name of the desired occurring item or group.
-
Double-click the value for the Occurring Item Table Name property, and type a name to identify the SQL table that contains the occurring item or occurring group.
-
(Optional) Double-click the value for the Occurrence Index Column Name property, and type a name for the column representing the occurrence index for the occurring item table.
If you do not specify a name, the column name is the name of the occurring item or occurring group table with a suffix of _INX.
-
If you want the occurrence index to be a required column and a not null column, select the Occurrence Index Is REQUIRED check box.
-
Select the Ignore check box to make the occurring item or occurring group inaccessible to SQL queries. Otherwise, leave the check box cleared.
