Handling metadata with the JDBC driver
The Microsoft JDBC Driver for SQL Server can be used to work with metadata in a SQL Server database in various ways. The JDBC driver can be used to get metadata about the database, a result set, or parameters.
The JDBC driver provides three classes for retrieving metadata from a SQL Server database:
- SQLServerDatabaseMetaData: Used to return information about the database that is currently connected.
- SQLServerResultSetMetaData: Used to return information about a result set.
- SQLServerParameterMetaData: Used to return information about the parameters of prepared and callable statements.
The articles in this section describe how you can use each of the three metadata classes to work with metadata in a SQL Server database.
Note
The metadata methods discussed in this section are generally expensive in terms of application performance, so care should be taken with their usage.
In this section
| Article | Description |
|---|---|
| Using database metadata | Describes how to retrieve metadata information about the currently connected database. |
| Using result set metadata | Describes how to retrieve metadata information about the current result set. |
| Using parameter metadata | Describes how to retrieve metadata information about the parameters of prepared and callable statements. |