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:

 

Have more questions? Submit a request

Comments

Article is closed for comments.

Powered by Zendesk