COMMENT -- define or change the comment of an object.
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.
The name of the table to be commented. The table name may be schema-qualified.
The name of a column within
table_name to be commented. The table name may be schema-qualified.
The new comment.
There is presently no security mechanism for comments: any user connected to a database can see all the comments for objects in that database (although only superusers can change comments for objects that they don’t own). Do not put security-critical information in a comment.
Attach a comment to the table
Attach a comment to the
empno column of the
Remove these comments: