16.20 - Querying Data Dictionary Views - Teradata Database - Teradata Vantage NewSQL Engine

Teradata Vantage™ Data Dictionary

Product
Teradata Database
Teradata Vantage NewSQL Engine
Release Number
16.20
Published
March 2019
Language
English (United States)
Last Update
2019-05-03
dita:mapPath
zzu1512081120577.ditamap
dita:ditavalPath
TD_DBS_16_20_Update1.ditaval

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 Teradata 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.