HELP SESSION CONSTRAINT | Teradata Vantage - 17.10 - Session Constraint Attributes - Advanced SQL Engine - Teradata Database

Teradata Vantage™ - SQL Data Definition Language Detailed Topics

Product
Advanced SQL Engine
Teradata Database
Release Number
17.10
Release Date
July 2021
Content Type
Programming Reference
Publication ID
B035-1184-171K
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