16.20 - Session Constraint Attributes - Teradata Database - Teradata Vantage NewSQL Engine

Teradata Vantage™ SQL Data Definition Language Detailed Topics

Product
Teradata Database
Teradata Vantage NewSQL Engine
Release Number
16.20
Release Date
March 2019
Content Type
Programming Reference
Publication ID
B035-1184-162K
Language
English (United States)

The HELP SESSION CONSTRAINT command is similar to the HELP SESSION command except that it returns additional information about row level security constraints.

The following table shows the attributes returned for each row level security constraint that applies to the session in addition to the normal HELP SESSION attributes.

Additional Attributes Data Type Nullable? Description
Constraint_ n_Name VARCHAR(30) Yes The name of a row level security constraint that applies to a session.

If no row level security constraint applies, the Constraint_n_Name is null.

Constraint_ n_Value   Yes The constraint value for the constraint name that immediately precedes it.

If no row level security constraint applies, the Constraint_n_Value is null.

Constraint _n Dictionary Name VARCHAR(128) No The attributes shown in this section are based upon and supersede the corresponding older Constraint_n_Name attribute, while providing additional functionality.

The older attribute is retained for compatibility with existing applications.

The system returns this set of attributes for each constraint applicable to the session.

For details, see the topics beginning with Object Name and Title Data in HELP Reports.

Constraint _n SQL Name VARCHAR(644) No
Constraint _n Uescape VARCHAR(1) Yes