SHOW LIBRARY

Use the SHOW LIBRARY command to display information about one or more user-defined shared libraries. The command checks your user account privileges to ensure that you are permitted to see information about the shared libraries that are defined in the database and schema.

Synopsis

The SHOW LIBRARY command has the following syntax:

SHOW LIBRARY [ALL | ident] [VERBOSE]

Inputs

The SHOW LIBRARY command takes the following inputs:

Table 1. SHOW LIBRARY inputs
Input	Description
ALL	Show information about all the libraries that are defined in the database. This is the default.
`ident`	Show information about one or more libraries that are defined in the database that begin with `ident`. You can specify a partial name.
VERBOSE	Display detailed information about the libraries.

Description

The SHOW LIBRARY command is identical in behavior to the nzsql \dl command.

Privileges required

Any user can run the command SHOW LIBRARY; however, you must be the admin user, own the library, or have object privileges on libraries (such as Execute, List, Alter, or Drop) to see information about libraries in the output.

Common tasks

Use the SHOW LIBRARY command to display information about the shared libraries in a database.

Usage

The following provides sample usage.

To show all the libraries, use the following command.

MYDB.SCHEMA(MYUSER)=> SHOW LIBRARY; 

    LIBRARY     | AUTOMATICLOAD
----------------+---------------
 MYLIB          | t
 MYMATHLIB      | t
 MYSQLTOOLSLIB  | f
(6 rows)

To show verbose information for the sample library named mylib, or any libraries that begin with the mylib string, use the following command.

DEV.SCHEMA(MYUSER)=> SHOW LIBRARY mylib VERBOSE;
    LIBRARY    | AUTOMATICLOAD | OWNER | DESCRIPTION | DEPENDENCIES
---------------+---------------+-------+-------------+--------------
 MYLIB         | t             | USER  |             |
 MYLIBMATH     | t             | USER  |             |
 MYLIBSPECIALS | t             | USER  |             | MYLIBMATH
(1 row)