SQL Views - 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

SQL Views

Teradata MDS provides SQL views for observing the relationships between tables, macros, views, and so on, as defined in the repository.

Each view provides data on some relationship, generally organized by system and database names. For example, the view meta_ViewTables returns the columns System, TableDatabase, TableName, ViewDatabase, and ViewName. The view meta_MacroTables returns similar info for macros, and so on for the other types that reference tables. For details about each view, see “Appendix C SQL Views” on page 179.