Schema Discovery
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:
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.