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:

Have more questions? Submit a request

Comments

Article is closed for comments.

Powered by Zendesk