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

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

Use create_foreign_constraint() or drop_foreign_constraint() to create or drop the constraint respectively.

A foreign key constraint can only be created on a global or central table and the foreign key constraint must reference an existing primary key constraint on the same or another table.

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

See create_foreign_constraint() and drop_foreign_constraint() for further information.