Querying Views | Data Dictionary | Teradata Vantage - Querying Data Dictionary Views - Advanced SQL Engine - Teradata Database

Data Dictionary

Product
Advanced SQL Engine
Teradata Database
Release Number
17.05
Published
January 2021
Language
English (United States)
Last Update
2021-01-22
dita:mapPath
prb1610499325399.ditamap
dita:ditavalPath
hoy1596145193032.ditaval
dita:id
B035-1092
lifecycle
previous
Product Category
Teradata Vantage™

You can submit an SQL request to access the data in a system view and display or print the results.

For example:

SELECT * FROM DBC.AccLogRules 
   WHERE UserName = ’ALL’;
If an SQL request returns a security violation error, a reference to the alternate version of the view name may yield results. If neither version is available, use the HELP statement to inquire about individual objects. If this is not adequate, consult with the database administrator.

The following sections show various methods for retrieving directory information.

For a description of several common administrative uses of the information in Data Dictionary views, see the topics starting with Tracking Resource Usage.