How do I add, create or drop a unique constraint on a table?

Connect to the network as a user with the star$define role granted to it.

Use create_unique_constraint() or drop_unique_constraint() to create or drop the constraint respectively.

A unique constraint can only be created on a global or central table.

You can create multiple unique constraints on a single table provided they each use different column combinations.

See create_unique_constraint() and drop_unique_constraint() for further information.