SHOW FUNCTIONS displays all
functions in the database. By default, both system functions and user-defined
functions appear in the output.

If IN schemaName is specified, then only the
functions in the specified schema are displayed.

Example

If you created the TO_DEGREES function described in "CREATE FUNCTION
statement" in the Java DB Reference Manual, the output of
the CREATE FUNCTION and SHOW FUNCTIONS commands would look something like the
following:

SHOW ROLES displays the names of all roles created, whether settable for the
current session or not.

SHOW ENABLED_ROLES displays the names of all the roles whose privileges are
available for the current session. That is, it shows the current role and any
role contained in the current role. (For a definition of role containment, see
"Using SQL roles" in the Java DB Developer's Guide.)

SHOW SETTABLE_ROLES displays all the roles that the current session can set,
that is, all roles that have been granted to the current user or to PUBLIC.