Using HELP and COMMENT - Teradata VantageCloud Lake

Lake - Database Reference

Deployment
VantageCloud
Edition
Lake
Product
Teradata VantageCloud Lake
Release Number
Published
February 2025
ft:locale
en-US
ft:lastEdition
2025-11-21
dita:mapPath
ohi1683672393549.ditamap
dita:ditavalPath
pny1626732985837.ditaval
dita:id
ohi1683672393549

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 get directory information about an object to 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.

See Comment, Help, and Show Statements .