15.10 - About Data Dictionary Views - Teradata Database

Teradata Database Data Dictionary

Teradata Database
Release Number
Content Type
User Guide
Publication ID
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 Utilities.

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” on page 17.

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” on page 23.

You can query views using SQL requests. For details, see “Querying Data Dictionary Views” on page 24.

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” on page 26.