COMMENTS

Returns information about comments associated with objects in the database.

Column Name Data Type Description
COMMENT_ID

INTEGER

The comment's internal ID number

OBJECT_ID

INTEGER

The internal ID number of the object associated with the comment

OBJECT_TYPE

VARCHAR

The type of object associated with the comment. Possible values are:

  • COLUMN
  • CONSTRAINT
  • FUNCTION
  • LIBRARY
  • NODE
  • PROJECTION
  • SCHEMA
  • SEQUENCE
  • TABLE
  • VIEW
OBJECT_SCHEMA

VARCHAR

The schema containing the object.

OBJECT_NAME

VARCHAR

The name of the object associated with the comment.

OWNER_ID

VARCHAR

The internal ID of the owner of the object.

OWNER_NAME

VARCHAR

The object owner's name.

CREATION_TIME

TIMESTAMPTZ

When the comment was created.

LAST_MODIFIED_TIME

TIMESTAMPTZ

When the comment was last modified.

COMMENT

VARCHAR

The text of the comments.