Commonly Used DatabaseMetaData Methods

JDBC Tutorials - Herong's Tutorial Examples - Version 3.03, by Dr. Herong Yang

JDBC Tutorials - Herong's Tutorial Examples

∟Microsoft JDBC Driver - DatabaseMetaData Object

∟Commonly Used DatabaseMetaData Methods

This section provides a list of commonly used DatabaseMetaData methods for obtaining information on database objects like tables, and stored procedures.

JDBC database meta data is a collection of information reported by the JDBC driver about the connected database. This collection of information can be obtained by con.getMetaData as a DatabaseMetaData object. Detailed information can be retrieved with various methods offered on the DatabaseMetaData object. Some of them are:

getDatabaseProductName() - Retrieves the name of this database product.
getDatabaseProductVersion() - Retrieves the version number of this database product.
getDriverName() - Retrieves the name of this JDBC driver.
getDriverVersion() - Retrieves the version number of this JDBC driver as a String.
getJDBCMinorVersion() - Retrieves the minor JDBC version number for this driver.
getJDBCMajorVersion() - Retrieves the major JDBC version number for this driver.
getUserName() - Retrieves the user name as known to this database.
getCatalogs() - Retrieves the catalog names available in this database.
getSchemas(String catalog, String schemaPattern) - Retrieves the schema names available in this database.
getTables(String catalog, String schemaPattern, String tableNamePattern, String[] types) - Retrieves a description of the tables available in the given catalog.
getPrimaryKeys(String catalog, String schema, String table) - Retrieves a description of the given table's primary key columns.
getColumns(String catalog, String schemaPattern, String tableNamePattern, String columnNamePattern) - Retrieves a description of table columns available in the specified catalog.
getProcedures(String catalog, String schemaPattern, String procedureNamePattern) - Retrieves a description of the stored procedures available in the given catalog.
getProcedureColumns(String catalog, String schemaPattern, String procedureNamePattern, String columnNamePattern) - Retrieves a description of the given catalog's stored procedure parameter and result columns.
getFunctions(String catalog, String schemaPattern, String functionNamePattern) - Retrieves a description of the system and user functions available in the given catalog.
getFunctionColumns(String catalog, String schemaPattern, String functionNamePattern, String columnNamePattern) - Retrieves a description of the given catalog's system or user function parameters and return type.