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

SQL Data Definition Language Detailed Topics

Product
Advanced SQL Engine
Teradata Database
Release Number
17.05
17.00
Published
June 2020
Language
English (United States)
Last Update
2021-01-24
dita:mapPath
jpx1556733107962.ditamap
dita:ditavalPath
lze1555437562152.ditaval
dita:id
B035-1184
lifecycle
previous
Product Category
Teradata Vantage™

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