meta_TVM - Teradata Meta Data Services

meta_TVM

Returns the tables, views, triggers, macros, procedures, hash indexes, and join indexes defined in systems being tracked by MDS. The TVType field returns 'T' (table), 'V' (view), 'G' (trigger), 'P' (procedure), 'HI' (hash index), and 'JI' (join index).

Table 149: Columns and Data Types of the meta_TVM View  

Column	Data Type
SystemName	VARCHAR(256)
DatabaseName	VARCHAR(128)
TVType	VARCHAR(2)
TVName	VARCHAR(128)
TVLoid	INTEGER
IsSynchronized	VARCHAR(6)
LastAlterTimestamp	TIMESTAMP
CreatorName	VARCHAR(128)