Data Dictionary Stored Information | Teradata Vantage - What the Data Dictionary Stores - Advanced SQL Engine - Teradata Database

Data Dictionary

Product
Advanced SQL Engine
Teradata Database
Release Number
17.00
Published
June 2020
Language
English (United States)
Last Update
2020-10-15
dita:mapPath
yoz1556235523563.ditamap
dita:ditavalPath
lze1555437562152.ditaval
dita:id
B035-1092
lifecycle
previous
Product Category
Teradata Vantageā„¢

Information about each database object is stored in the system tables.

System tables cannot be directly modified and are used by the system to manage and maintain the integrity of the database.

Information in the system tables is used to create, access, modify and execute objects and user data stored in Vantage.

The primary system tables include:
  • Dbase: This table contains information about every database installed on the system. Database information includes names associated with this database (for example, database name, owner name, and account name), timestamps, passwords, and so on.
  • DataBaseSpace: This table contains space allocation for each database.
  • TVM and TVFields: These two tables contain information about every table, view, macro and other objects that are stored in the databases.
  • Accessrights: This table contains all of the information about user permissions for each type object stored in the database.
Vantage supports the following database objects:
  • Stored Procedures written in SQL and external procedures written in C/C++ and Java.
  • User-defined types (UDTs), user-defined functions (UDFs), and user-defined methods (UDMs). These functions and methods provide you with the toolset to perform whatever type of processing and manipulation of data is required.

For detailed descriptions of these objects, see Database Objects.