17.00 - About Data Dictionary Views - Teradata Database

Teradata Vantage™ - Data Dictionary

prodname
Advanced SQL Engine
Teradata Database
vrm_release
17.00
created_date
June 2020
category
Administration
Programming Reference
featnum
B035-1092-170K

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.