drop_foreign_constraint

Drops an existing foreign key 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 foreign key constraint is defined.
columns$	Mandatory	Text	The columns included in the foreign key constraint.

Examples:

SELECT drop_foreign_constraint('mytable','col1'); -- drops the foreign key constraint on column 'col1' on table 'mytable'.

SELECT drop_foreign_constraint('mytable','col1,col2); -- drops the foreign key constraint on columns 'col1' and 'col2' on table 'mytable'.

Tips:

• The star$constraints view indicates which constraints exist.