create_distribution_constraint

Creates a distribution key constraint on a local table. A distribution constraint can be defined on one column and only one distribution constraint can be defined on a table.

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

Parameters:

Name	Optional	Type	Description
table$	Mandatory	Text	The table to create the distribution constraint on.
column$	Mandatory	Text	The column in the distribution constraint.

Examples:

SELECT create_distribution_constraint('mytable','cola'); -- creates a distribution constraint on column 'cola'.

Tips:

• The star$constraints view indicates which constraints already exist.