HELP SESSION CONSTRAINT | Teradata Vantage - Session Constraint Attributes - Analytics Database - Teradata Vantage

SQL Data Definition Language Detailed Topics

Deployment
VantageCloud
VantageCore
Edition
Enterprise
IntelliFlex
VMware
Product
Analytics Database
Teradata Vantage
Release Number
17.20
Published
June 2022
Language
English (United States)
Last Update
2023-07-11
dita:mapPath
vuk1628111288877.ditamap
dita:ditavalPath
qkf1628213546010.ditaval
dita:id
B035-1184
lifecycle
latest
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