Predicate_Field - Teradata Vantage

Teradata® VantageCloud Lake
Deployment
VantageCloud
Edition
Lake
Product
Teradata Vantage
Published
January 2023
ft:locale
en-US
ft:lastEdition
2024-12-11
dita:mapPath
phg1621910019905.ditamap
dita:ditavalPath
pny1626732985837.ditaval
dita:id
phg1621910019905

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.