CREATE CONSTRAINT SQL Statement | VantageCloud Lake - CREATE CONSTRAINT - Teradata VantageCloud Lake

Lake - Working with SQL

Deployment
VantageCloud
Edition
Lake
Product
Teradata VantageCloud Lake
Release Number
Published
February 2025
ft:locale
en-US
ft:lastEdition
2025-11-21
dita:mapPath
jbe1714339405530.ditamap
dita:ditavalPath
pny1626732985837.ditaval
dita:id
jbe1714339405530

Creates the SQL row-level security constraint definition and associates it with specific UDFs to enforce that constraint.

Before creating a constraint you must:
  • Design the classification system that defines the set of name:value pairs that must be specified for the constraint.
  • Create the UDFs that enforce the constraint, which you must specify for SYSLIB.function_name.

ANSI Compliance

This statement is a Teradata extension to the ANSI SQL:2011 standard.

There are no ANSI standards for row-level security-related SQL statements.

Required Privileges

You must have the CONSTRAINT DEFINITION privilege to create a row-level security constraint.

Privileges Granted Automatically

None.