drop_unique_constraint

Drops an existing unique constraint on a global or central table. 

Available in a network database and requires the star$define role.

Parameters:

Name	Optional	Type	Description
table$	Mandatory	Text	The table on which the primary key constraint is defined.
columns$	Mandatory	Text	The columns included in the unique constraint.

Examples:

SELECT drop_unique_constraint('mytable','col1'); -- drops the unique constraint on column 'col1' on table 'mytable'.

SELECT drop_unique_constraint('mytable','col1,col2'); -- drops the unique constraint on columns 'col1' and 'col2' on table 'mytable'.

Tips:

• The star$constraints view indicates which constraints exist.