The driver supports schema discovery using JDBC classes or using SQL queries to the available system tables. The JDBC classes enable access to schema information, connection property information, and information on the columns returned.

Through SQL queries to the available System Tables, you can access schema and connection property information as well as information on data source functionality and statistics on update operations.

Using JDBC Interfaces

You can use JDBC interfaces to access schema information, connection property metadata, and result set metadata. The driver implements the standard interfaces as defined in the JDBC 4.0 specification.

Retrieving Schema Information

The DatabaseMetaData class provides information on the following:

• Tables
• Columns
• Primary Keys
• Foreign Keys

Retrieving Connection Property Information

The Driver class, returned by DriverManager, provides information about Connection Properties.

Retrieving Result Set Column Information

The ResultSetMetaData class provides information about the columns returned in Result Sets.

Using SQL

You can query the System Tables to access any metadata surfaced through the driver.