The COMMENT ON statement adds or replaces comments in the catalog descriptions of various database objects. You can add a comment to the following:
You can also add comments for multiple columns and multiple parameters.
Insert a comment for the EMPLOYEE table.
COMMENT ON TABLE CORPDATA.EMPLOYEE IS 'Reflects first quarter 2001 reorganization'
Insert a comment for two columns in the DEPARTMENT table.
COMMENT ON COLUMN CORPDATA.DEPARTMENT (MGRNO IS 'EMPLOYEE NUMBER OF DEPARTMENT MANAGER', ADMRDEPT IS'DEPARTMENT NUMBER OF ADMINISTERING DEPARTMENT')
For more information, see COMMENT ON in the SQL Reference topic in the
Information Center.