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
This statement is a Teradata extension to the ANSI SQL:2011 standard.
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