Display Table References - Teradata Administrator

Teradata Administrator User Guide

Product
Teradata Administrator
Release Number
15.00
Language
English (United States)
Last Update
2018-09-27
dita:id
B035-2502
lifecycle
previous
Product Category
Teradata Tools and Utilities

Display Table References

The References report shows:

  • All Triggers and Join Indexes defined on the selected table.
  • All tables that reference the selected table through a Foreign Key Constraint.
  • All Views and Macros that directly reference the selected table.
  • Note: This feature is only available for those who have Select access on the dbc.DBase, dbc.TVM, and dbc.TextTbl tables.

    The References report does not show indirect references to tables or views, such as when a Macro calls a view which is based on a table or another view. This lower level table or view does not show up in the references report.

    Use the following procedure to view information about references for the selected table.

    To view all references for the selected table

    1 Select the table(s) in the grid.

    2 From the main window, click Object>References.

    Teradata Administrator searches for references that are in the overflow table (dbc.TextTbl) and the dbc.TVM table.