16.20 - Using HELP and COMMENT - 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

If the SELECT privilege on one or more system views is revoked or not granted to PUBLIC, you can use the HELP and COMMENT statements to obtain directory information about a particular object for which you have access.

HELP does not require long or complex queries and the results can be formatted for printing.

The COMMENT statement returns descriptive information about a database or database object. This includes information about Data Dictionary views.

For example, the following COMMENT statement:

COMMENT ON DBC.UserGrantedRightsV;

returns the following description:

The DBC.UserGrantedRightsV view provides information on access rights that the current user has granted to other users. The column names are: DatabaseName, TableName, FieldName, Grantee, AccessRight, WithGrant and AllnessFlag.

For more information on HELP and COMMENT, see Teradata Vantage™ SQL Data Definition Language Syntax and Examples, B035-1144.