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 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. |
| GLOP | DROP GLOP. |
Privileges Granted Automatically
None.