17.10 - About Data Dictionary Views - Advanced SQL Engine - Teradata Database

Teradata Vantage™ - Data Dictionary

Product
Advanced SQL Engine
Teradata Database
Release Number
17.10
Release Date
July 2021
Content Type
Administration
Programming Reference
Publication ID
B035-1092-171K
Language
English (United States)

During initial system setup, the Database Initialization Program (DIP) creates pre-defined Data Dictionary views, which allow convenient access to data stored in Data Dictionary base tables. For more information about DIP, see Teradata Vantage™ - Database Utilities, B035-1102.

The DIP script run as part of system setup creates several types of Data Dictionary views with varying purposes. For more information about the Data Dictionary views, see Types of Views.

Many Data Dictionary views are accessible by all users by default, but some are restricted. For information about the privileges for Data Dictionary views, see Access to Data Dictionary Views.

You can query views using SQL requests. For details, see Querying Data Dictionary Views.

Data Dictionary views are used by administrators and by administrative tools, such as Teradata Viewpoint. For more about how Data Dictionary views are used, see Tracking Resource Usage.