16.20 - COMMENT (Comment Placing Form) - Teradata Database - Teradata Vantage NewSQL Engine

Teradata Vantage™ SQL Data Definition Language Syntax and Examples

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

Purpose

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.

Syntax