| title | description | author | ms.author | ms.date | ms.service | ms.subservice | ms.topic |
|---|---|---|---|---|---|---|---|
Handling metadata |
Learn what metadata is available in the different JDBC objects when using the JDBC Driver for SQL Server. |
David-Engel |
davidengel |
04/20/2021 |
sql |
connectivity |
conceptual |
[!INCLUDEDriver_JDBC_Download]
The [!INCLUDEjdbcNoVersion] can be used to work with metadata in a [!INCLUDEssNoVersion] 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 [!INCLUDEssNoVersion] 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 [!INCLUDEssNoVersion] 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.
| 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. |