COMMENT SQL Statement | Teradata Vantage - COMMENT (Comment Placing Form) - Advanced SQL Engine - Teradata Database

SQL Data Definition Language Syntax and Examples

Product
Advanced SQL Engine
Teradata Database
Release Number
17.00
Published
September 2020
Language
English (United States)
Last Update
2021-01-23
dita:mapPath
wgr1555383704548.ditamap
dita:ditavalPath
lze1555437562152.ditaval
dita:id
B035-1144
lifecycle
previous
Product Category
Teradata Vantage™

Creates a user-defined description of a user-defined database object or definition in the data dictionary.

When you add a comment for an object, the new comment is added to the data dictionary, replacing any existing comment.

When you display a comment for an object, the comment text in the data dictionary is returned. Otherwise, null is returned if the object does not have a comment. For information on the comment returning form of the COMMENT statement, see “COMMENT (Comment-Returning Form)” in Teradata Vantage™ - SQL Data Manipulation Language, B035-1146

Required Privileges

The following privileges are required to place a COMMENT.

Create or Replace Object Comment Privilege Required
Object or definition other than a UDT or method DROP on the object.

If the object is a column, then you must have the DROP privilege on the object in which the column is defined.

Comment on a method UDTMETHOD on the SYSUDTLIB database.
User-defined data type UDTTYPE on the SYSUDTLIB database.
GLOP DROP GLOP.

Privileges Granted Automatically

None.