16.20 - VALUES - Teradata Database - Teradata Vantage NewSQL Engine

Teradata Vantage™ SQL Data Definition Language Syntax and Examples

Teradata Database
Teradata Vantage NewSQL Engine
Release Number
March 2019
Content Type
Programming Reference
Publication ID
English (United States)
Last Update

The string to follow is a set of name:value pairs, which defines either a hierarchical (level) or non-hierarchical (category) classification system.

The set of name:value pairs defines the set of classifications for the constraint.

The maximum number of name :value pairs depends on whether the constraint is hierarchical (10,000) or non-hierarchical (256).

The name of a member of the classification system being defined for the constraint.
One or more of the classification names for the constraint can be assigned to a user or profile to define their access privileges on tables that contain the constraint.
The value code for the corresponding name in a name:value pair.
Value codes appear for each row in the corresponding constraint column of tables protected by the constraint.
For details about name:value pairs and how the value is determined for a table row, see “Implementing Row-Level Security” in Teradata Vantage™ Resource Usage Macros and Tables, B035-1099.