Displays information about specified modules.

    If you do not specify any of the SHOW MODULES options listed in
    the following table, SQL displays information about all these
    options:

    You
    Specify
    This:       SQL Displays Information About:

    COMMENT     The description of the module. If none exists,
                nothing displays.
    FUNCTIONS   The stored functions contained in the module.
    ID          The unique identification assigned to the module.
    NAME        The name of the module.
    OWNER       The owner of the module. If the module is a definer's
                rights module, the definer's user name displays,
                otherwise for an invoker's rights module the output
                will be blank.
    PROCEDURES  The stored procedures contained in the module.
    VARIABLES   Displays module global variables.