meta_CheckConstraints - 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_CheckConstraints

Returns the current CHECK constraints for the tables in systems being tracked by MDS. Corresponds to the relationship TableHasCheckConstraints.

 

Table 79: Columns, Data Types, and Values of the meta_CheckConstraints View  

Column

Data Type

Values

SystemName

VARCHAR(256)

 

DatabaseName

VARCHAR(128)

 

TableName

VARCHAR(128)

 

CheckName

VARCHAR(128)

 

CheckLoid

INTEGER

 

CheckType

CHAR(1)

 

CheckTypeA

VARCHAR(18)

  • Constraint Check
  • Partitioning Check
  • CheckBool

    VARCHAR(8192)