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

Teradata Vantage™ - SQL Data Definition Language Syntax and Examples

Product
Advanced SQL Engine
Teradata Database
Release Number
17.00
Release Date
September 2020
Content Type
Programming Reference
Publication ID
B035-1144-170K
Language
English (United States)

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.