On this page
SHOW DRIVERS
Core command
SH DR
SHDR
Lists the JDBC drivers found in the drivers and lib folders.
Syntax
SHOW DRIVERS [DETAILED]
Arguments
| Argument | Required | Values | Default |
|---|---|---|---|
DETAILED | No | Shows each driver's JAR file and driver classes | One summary row per driver |
Examples
SHOW DRIVERS;
SHOW DRIVERS DETAILED;
Details
The command searches every JAR file of the drivers and lib folders, relative to the current working directory, for JDBC driver classes (java.sql.Driver).
- By default, it prints one row per driver: name, version and vendor.
- With
DETAILED, it prints a block per driver instead, including its JAR file and driver class names.
It ends with the number of drivers found. Reading every JAR file can take a noticeable time on a large installation.
Related
- Technical requirements, the bundled drivers
- Connections
Last modified in release 5.5.0.
Found something wrong or unclear on this page? Tell us, with the page address.