Example: Modifying an Existing Table Constraint

There are a few ways in which you can modify a table constraint. You can change the status of an existing table constraint, for example, from an enabled state to a disabled state. In this example, you disable the check constraint that you created for the purchase_orders table in "Example: Adding a New Table Constraint".

To disable a constraint for the PURCHASE_ORDERS table:

1. Go to the Database Home page, logging in as user nick or as user SYSTEM.

   See "Accessing the Database Home Page".

2. At the top of the page, click Schema to view the Schema subpage.

3. In the Database Objects section, click Tables.

   The Tables page appears.

4. In the Schema field, enter nick and then click Go.

   All tables owned by user nick are displayed.

5. Select the purchase_orders table, and then click Edit.

   The Edit Table page appears.

6. Click Constraints to display the Constraints subpage.

7. Select the constraint named PO_CHECK_RCVD_DATE, and then click Edit.

   The Edit CHECK Constraint page appears.

8. In the Attributes section, select Disabled, and then click Continue.

9. Click Apply.

   A confirmation message appears. The Disabled column shows that the check constraint has been disabled.