3.3.13 COMMENT

Table of Contents Previous Next



3.3.13 COMMENT
COMMENT -- define or change the comment of an object
TABLE table_name |
COLUMN table_name.column_name
} IS 'text'
COMMENT stores a comment about a database object. To modify a comment, issue a new COMMENT command for the same object. Only one comment string is stored for each object. To remove a comment, specify the empty string (two consecutive single quotes with no intervening space) for text. Comments are automatically dropped when the object is dropped.
table_name.column_name
The name of a column within table_name to be commented. The table name may be schema-qualified.
Attach a comment to the empno column of the emp table:


Table of Contents Previous Next