meta_RefConstraintColumns - Teradata Meta Data Services

Teradata Meta Data Services User Guide

Product
Teradata Meta Data Services
Release Number
15.00
Language
English (United States)
Last Update
2018-09-27
Product Category
Teradata Tools and Utilities

meta_RefConstraintColumns

Returns the table columns comprising the current REFERENCE constraints in systems being tracked by MDS. Corresponds to the relationship ConstraintReferencesColumns.

 

Table 121: Columns and Data Types of the meta_RefConstraintColumns View  

Column

Data Type

SystemName

VARCHAR(256)

DatabaseName

VARCHAR(128)

TableName

VARCHAR(128)

ReferenceId

SMALLINT

ReferenceName

VARCHAR(128)

ForeignKeyColumnName

VARCHAR(128)

ReferencedDatabaseName

VARCHAR(128)

ReferencedTableName

VARCHAR(128)

ReferencedColumnName

VARCHAR(128)