The COMMENT statement allows you to set a remark (comment) for an object in the database. The COMMENT statement updates remarks
listed in the ISYSREMARK system table. You can remove a comment by setting it to NULL. For a comment on an index or trigger,
the owner of the comment is the owner of the table on which the index or trigger is defined.
You cannot add comments for local temporary tables.
If you use the Database Documentation Wizard to document your SQL Anywhere database, you have the option to include the comments for procedures, functions, triggers,
events, and views in the output.
If you have the COMMENT ANY OBJECT system privilege, you can comment on any you can create with the CREATE ANY OBJECT system
privilege. If you do not have the COMMENT ANY OBJECT system privilege, you must have the equivalent as noted below:
For database objects, at least one of the following must be true:
you own the object
you have the ability to create or alter objects of the same type owned by other users (for example, CREATE ANY TABLE, or ALTER
you have the ability to manage objects of that type (for example, MANAGE ANY USER)
For system roles, you must have administrative privilege over the role.
For user-defined roles, you must have the MANAGE ROLES system privilege, or have administrative privilege over the role.
For Kerberos or integrated logins, you must have the MANAGE ANY USER system privilege.
For Java classes or jars, you must have the MANAGE ANY EXTERNAL OBJECT system privilege.