COMMENTS

Returns information about comments associated with objects in the database.

Returns information about comments associated with objects in the database.

Column Name Data Type Description
COMMENT_ID INTEGER Comment's internal ID number
OBJECT_ID INTEGER Internal ID number of the object associated with the comment.
OBJECT_TYPE VARCHAR

Type of object associated with the comment, one of the following:

  • COLUMN

  • CONSTRAINT

  • FUNCTION

  • LIBRARY

  • NODE

  • PROJECTION

  • SCHEMA

  • SEQUENCE

  • TABLE

  • VIEW

OBJECT_SCHEMA VARCHAR Schema that contains the object.
OBJECT_NAME VARCHAR Name of the object associated with the comment.
OWNER_ID VARCHAR Internal ID of the object's owner.
OWNER_NAME VARCHAR Object owner's name.
CREATION_TIME TIMESTAMPTZ When the comment was created.
LAST_MODIFIED_TIME TIMESTAMPTZ When the comment was last modified.
COMMENT VARCHAR Comment text.