15.10 - COMMENT (Comment Placing Form) - Teradata Database

Teradata Database SQL Data Definition Language Syntax and Examples

prodname
Teradata Database
vrm_release
15.10
created_date
December 2015
category
Programming Reference
featnum
B035-1144-151K

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 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