Each row in the SYSREMARK system view describes a remark (or comment) for an object. The underlying system table for this view is ISYSREMARK.
|Column||Data type||Column Constraint|
|object_id||UNSIGNED BIGINT||NOT NULL|
|remarks||LONG VARCHAR||NOT NULL|
object_id The internal ID for the object that has an associated remark.
remarks The remark or comment associated with the object.
PRIMARY KEY (object_id)
FOREIGN KEY (object_id) references SYS.ISYSOBJECT (object_id) MATCH UNIQUE FULL