Displays information about a specified procedure; either external
    or stored.

    If you do not specify any of the SHOW PROCEDURES attributes
    (COMMENT, ID, LANGUAGE, MODULE, OWNER, SOURCE, or PARAMETER),
    by default you will see the display for all these options.

    You
    Specify
    This:       SQL Displays Information About:

    COMMENT     The description of the stored procedure. If none
                exists, nothing displays.
    ID          The unique identification assigned to the procedure.
    LANGUAGE    The language in which the procedure source is coded.
    MODULE      The identification number of the module to which a
                procedure belongs.
    OWNER       The owner of the procedure.
    PARAMETER   Information about the parameters; including the
                number of arguments, the data type, and how the
                parameter is passed.
    SOURCE      Displays the source definitions for the specified
                procedures.