Events
Mar 31, 11 PM - Apr 2, 11 PM
The biggest SQL, Fabric and Power BI learning event. March 31 – April 2. Use code FABINSIDER to save $400.
Register todayHandling 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.
| 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. |
Additional resources
Training
Module
Use system catalogs and system views in PostgreSQL - Training
Relational databases can store vast quantities of data, but they also need to hold information about the structure of that data. For an operational database management system (DBMS) information about the structure of tables, and all other objects, security, and concurrency, amongst many other settings and metrics, is required. This information is know as metadata and is stored in system catalogs in Azure Database for PostgreSQL. In addition to directly accessing system catalogs, you can access system views
Certification
Microsoft Certified: Azure Database Administrator Associate - Certifications
Administer an SQL Server database infrastructure for cloud, on-premises and hybrid relational databases using the Microsoft PaaS relational database offerings.