Archiving data dictionary 

A dictionary's actual meaning is a resource of words for a particular language, which provides their meaning. Similarly, we have this feature in Teradata Database. 

The Teradata data dictionary (DD) is a complete database composed of system tables, views, and macros that reside in the Teradata system, called DBC. Data dictionary tables are dumped when you install the system. Users reference some of these tables with SQL requests, while others are used for system or data recovery only. Data dictionary views reference data dictionary tables. Views and macros are created by running Database Initialization Program (DIP) scripts. 

Data dictionary tables are used to:

  • Store definitions of objects you create (for example ...

Get Teradata Cookbook now with the O’Reilly learning platform.

O’Reilly members experience books, live events, courses curated by job role, and more from O’Reilly and nearly 200 top publishers.