Example 1: Insert a comment for the EMPLOYEE table.
COMMENT ON TABLE EMPLOYEE IS 'Reflects first quarter 2000 reorganization'
Example 2: Insert a comment for the EMP_VIEW1 view.
COMMENT ON TABLE EMP_VIEW1 IS 'View of the EMPLOYEE table without salary information'
Example 3: Insert a comment for the EDLEVEL column of the EMPLOYEE table.
COMMENT ON COLUMN EMPLOYEE.EDLEVEL IS 'Highest grade level passed in school'
Example 4: Enter comments on two columns in the DEPARTMENT table.
COMMENT ON DEPARTMENT (MGRNO IS 'EMPLOYEE NUMBER OF DEPARTMENT MANAGER', ADMRDEPT IS 'DEPARTMENT NUMBER OF ADMINISTERING DEPARTMENT')
Example 5: Insert a comment for the PAYROLL package.
COMMENT ON PACKAGE PAYROLL IS 'This package is used for distributed payroll processing.'
(C) Copyright IBM Corporation 1992, 2006. All Rights Reserved.