Remove a constraint

  1. In the System i Navigator window, expand the system you want to use.
  2. Expand Databases.
  3. Expand the database and schema that you want to work with.
  4. Click the schema that contains the table from which you want to remove the constraint or trigger.
  5. Right-click the table from which you want to remove the constraint or trigger and select Definition.
  6. On the Table Definition dialog, click the tab for the type of constraint or trigger that you want to remove.
  7. Select the constraint that you want to remove and click Delete.

You can also delete a constraint by click the Constraint container, right-clicking the constraint that you can to delete, and selecting Delete.