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:

 

Have more questions? Submit a request

Comments

Article is closed for comments.

Powered by Zendesk