The Teradata Database Data Dictionary is composed of tables and views that reside in the system user named DBC. The tables are reserved for use by the system and contain metadata about the objects in the system, privileges, system events, and system usage. The views provide access to the information in the tables. The tables contain current definitions, control information, and general information about the following:
|
|
|
The Data Dictionary stores object definitions as well as details about objects.
Object |
Details Stored |
Table |
|
Database |
|
View or macro |
|
Stored procedure |
|
External stored procedure |
|
JAR |
|
Java external stored procedure |
|
Java user-defined function (UDF) |
|
Trigger |
|
UDF |
|
User-defined method (UDM) |
|
User-defined type (UDT) |
DBC.UDTInfo - one entry per UDT DBC.UDTCast - one entry per cast for a UDT DBC.UDFInfo - one entry for the UDT's auto-generated default constructor; entries are the same as for a regular (C/C++) UDF DBC.UDTTransform - one entry for the UDT's transform |
User |
|