14. Teradata Data Dictionary

The Data Dictionary (DD)

The Data Dictionary (DD) is an integrated set of system tables that:

-

Stores database object definitions and accumulates information about

users

, databases, resource usage, data demographics, and

security rules

.

-

Records specifications about tables, views, and macros.

-

Contains information about ownership, space allocation,

accounting

, and access rights (privileges) for these objects.

Data Dictionary information is updated automatically during the processing

of Teradata SQL

data definition language (DDL) statements. It is used

by the Parser to obtain information needed to process all Teradata SQL

statements.

Users may access the Data Dictionary through Teradata-supplied views, if
permitted by the System Administrator.