| Note: | This task applies only to an Enterprise Database Server database that is mapped to SQL. |
Perform the following steps to modify data 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 a data set in the database.
-
Expand the Columns node to display the data items associated with the table.
-
Select the data item you want to modify.
-
Double-click the value for the Alias Column Name property or Alias Primary Key Name property, and type the name used for the SQL table represented by the data item. The alias name can be up to 30 characters long.
-
Select the Ignore check box to make the data item inaccessible to SQL queries. Otherwise, leave the check box cleared.
| Note: | Occurring items and variable-format items are also mapped as tables. They can also contain columns. To access the columns for these tables, expand the node representing the occurring item table or variable-format item table. |
