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

Teradata Vantage™ - SQL Data Definition Language Syntax and Examples

Advanced SQL Engine
Teradata Database
Release Number
Release Date
January 2021
Content Type
Programming Reference
Publication ID
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 Teradata Vantage™ - SQL Data Manipulation Language, B035-1146

ANSI Compliance

This statement is a Teradata extension to the ANSI SQL:2011 standard.

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.

Privileges Granted Automatically