Adding a Primary Key Constraint

Previous

Next

You can use Object Browser to add a primary key constraint on a column in a table. The primary key uniquely identifies each record (row) that is inserted in the table and ensures that no duplicate rows exist. For information about the primary key constraint, see "Primary Key Constraint".

To add a primary key constraint:

1. Log in to the Database Home Page. See "Logging in to the Database Home Page".

2. On the Database Home Page, click the Object Browser icon.

3. In the Object list, select Tables then click the personal_info table that you previously created.

4. Click the Constraints tab.

5. Click the Create button.

6. On the Add Constraint page, use following information to complete the page:

   Constraint Name: PERSONAL_INFO_PKEY

   Constraint Type: Primary Key

   Primary Key Column 1: EMPLOYEE_ID(NUMBER)

7. Click the Next button.

8. Click the Finish button to complete the action.