Managed tables design: Unique Constraints

You can create a unique constraint in to ensure no duplicate values are entered in specific columns that do not participate in a primary key. This implies that if one of the steps in your process tries to insert data into the managed table and there duplicates the step will fail.

How to set up a constraint on your managed table

1. Open the managed table.

2. Click Add uniqueness constraint.

3. Select columns that will form a constraint for your table.

4. Click Save.

• Columns in the managed table structure will have icon identifying that they are a part of a constraint.
• Note that you cannot change (edit name, type or delete) these columns until you remove them from the constraint.

How to change the constraint on a managed table

1. Open the managed table.

2. Click on the constraint to change it.

3. Change columns that should form your new constraint.

4. Hit Apply.

5. Click Save.

How to delete a constraint from managed table

1. Open the managed table.

2. Click on the constraint.

3. Click Delete unique constraint.

4. Click Save.