16.10 - Database Objects and Information - Teradata Unity

Teradata Unity User Guide

Product
Teradata Unity
Release Number
16.10
Published
January 2018
Language
English (United States)
Last Update
2018-03-29
dita:mapPath
anz1496162519675.ditamap
dita:ditavalPath
ft:empty
The Data Dictionary manages the following database objects and information.
Object Detailed Information
Database Name Name of Teradata database
Table
  • Table name
  • Any primary index column names
  • Column names and data type for identity columns
  • Table attributes
Views
  • View name
  • List of columns from the source table in the view and whether the column has a different name in the view
  • List of tables from which the view reads and writes to
  • User-defined functions or stored procedures the view calls
  • View attributes
Triggers
  • Trigger name
  • Name of table to which the trigger is attached
  • Event that runs the trigger
  • List of tables from which the trigger reads and writes to
  • User-defined functions or stored procedures the trigger calls
References
  • Referential integrity constraint name
  • Parent table
  • Child table
User-Defined Functions
  • User-defined functions or stored procedures the stored procedure calls
  • Number of parameters
Stored Procedures
  • Name of stored procedure
  • Number of parameters
  • Flag if the stored procedure performs a write operation
  • Tables the stored procedure reads from or writes to
  • If the stored procedure returns a result set:
    • Number of columns in return
    • Whether to ignore a specific column in the response hash comparison result set
  • Stored procedure attributes
Macros
  • Macro SQL text
  • Macro attributes
  • Referenced macros and tables/views