16.10 - Predicate_Field - Teradata Database

Teradata Database SQL Request and Transaction Processing

prodname
Teradata Database
vrm_release
16.10
created_date
June 2017
category
Programming Reference
User Guide
featnum
B035-1142-161K

Function of Predicate_Field

Associates the list of columns specified in a captured predicate with the parent relation and predicate.

Predicate_Field Table Definition

The following CREATE TABLE request defines the Predicate_Field table:

CREATE TABLE predicate_field (
  PredicateID INTEGER NOT NULL,
  RelationKey INTEGER NOT NULL,
  FieldID     INTEGER NOT NULL)
PRIMARY INDEX ( RelationKey );

Attribute Definitions for Predicate_Field

The following table defines the Predicate_Field table attributes:

Attribute Definition
PredicateID Uniquely identifies the predicate.
RelationKey
  • Unique identifier for the referenced table.
  • NUPI for the Predicate_Field table.
FieldID Unique identifier for the column.