Adding primary keys to user-defined objects

Primary keys can be added to user-defined objects to uniquely identify these objects in a database. A primary index is automatically created for the primary key and ensures that the primary key is unique.

Before you begin

You must be logged in as a global administrator.

You must be logged in as an administrator.

About this task

By default, the system assigns the unique ID attribute as the primary key by assigning a value of 1 to the Primary Column field of this attribute. You can clear this value, or enter your own value in the Primary Column.

1. In the Database Configuration application, create an object or open the object to which you want to add a primary key.
2. On the Attributes tab, assign a value to one or more attributes in the Primary Column.
3. Save the object.