15.00 - HELP SESSION CONSTRAINT - Teradata Database

Teradata Database SQL Data Definition Language Detailed Topics

prodname
Teradata Database
vrm_release
15.00
category
Programming Reference
featnum
B035-1184-015K

HELP SESSION CONSTRAINT

Session Constraint Attributes

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 “Working with Object Name and Title Data in HELP Reports” on page 896.

Constraint_n SQL Name

VARCHAR(644)

No

Constraint_n Uescape

VARCHAR(1)

Yes