15.10 - Predicate_Field - Teradata Database

Teradata Database SQL Request and Transaction Processing

prodname
Teradata Database
vrm_release
15.10
category
Programming Reference
User Guide
featnum
B035-1142-151K

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

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 );

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.