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

ArgumentRequiredValuesDefault
DETAILEDNoShows each driver's JAR file and driver classesOne 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.

Last modified in release 5.5.0.

Found something wrong or unclear on this page? , with the page address.