17.10 - Predicate_Field - Advanced SQL Engine - Teradata Database

Teradata Vantage™ - SQL Request and Transaction Processing

Product
Advanced SQL Engine
Teradata Database
Release Number
17.10
Release Date
July 2021
Content Type
Programming Reference
User Guide
Publication ID
B035-1142-171K
Language
English (United States)

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.