Teradata -- Data Dictionary Directory (DD/D)

The DD/D ( Data Dictionary Directory) ...

• is an integrated set of system tables
• contains definitions of and information about all objects in the system
• is entirely maintained by the RDBMS
• is “data about the data” or “metadata”
• is distributed across all AMPs like all tables
• may be queried by administrators or support staff
• is accessed via Teradata supplied views

Examples of DD/D views:

DBC.Tables ---> information about all tables
DBC.Users ---> information about all users
DBC.AllRights ---> information about access rights
DBC.AllSpace ---> information about space utilization