meta_TV - 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_TV

Returns the tables and views defined in systems being tracked by MDS. The TVType field returns 'T' for a table and 'V' for a view.

 

Table 147: Columns and Data Types of the meta_TV View  

Column

Data Type

SystemName

VARCHAR(256)

DatabaseName

VARCHAR(128)

TVType

VARCHAR(2)

TableName

VARCHAR(128)

TableLoid

INTEGER

IsSynchronized

VARCHAR(6)

LastAlterTimestamp

TIMESTAMP

CreatorName

VARCHAR(128)