5.16.1. COMMENT ON

    Used for

    Documenting metadata

    Available in

    DSQL

    Syntax

    The COMMENT ON statement adds comments for database objects (metadata). Comments are saved to text fields of the BLOB type in the RDB$DESCRIPTION column of the corresponding system tables. Client applications can view comments from these fields.

    If you add an empty comment (“‘’”), it will be saved as in the database.

    The table or procedure owner and Administrators have the authority to use COMMENT ON.

    Examples using COMMENT ON

    1. Adding a comment for the METALS table

    2. Adding a comment for a parameter