Disabling and Enabling a Constraint

Previous

Next

You can use Object Browser to disable or enable a constraint.

To disable and enable a 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 Disable button.

6. On the Disable Constraint page, select the check constraint that you created on the dependents_claimed column (PERSONAL_INFO_CHECK_CON). See "Viewing Existing Constraints" to determine the name of the constraint.

7. Click the Next button.

8. Click the Enable button on the Constraints tab.

9. On the Enable Constraint page, select the check constraint that you created on the dependents_claimed column (PERSONAL_INFO_CHECK_CON). See "Viewing Existing Constraints" to determine the name of the constraint.

10. Click the Next button.

11. Click the Finish button to complete the action.