Microsoft JDBC Driver - DatabaseMetaData Object

JDBC for SQL Server - Herong's Tutorial Examples

∟Microsoft JDBC Driver - DatabaseMetaData Object

This chapter provides tutorial notes on using DatabaseMetaData object to obtain information on database objects. Topics include getting SQL server and JDBC driver information; listing all databases on the SQL Server; listing all tables, stored procedures and schemas in the current database; listing all columns in a table or a view.

Commonly Used DatabaseMetaData Methods

Getting Database Server and Driver Info

Listing All Databases - getCatalogs()

Listing All Schemas - getSchemas()

Listing All Tables - getTables()

Listing All Culumns - getColumns()

Listing All Stored Procedures - getProcedures()

Takeaways:

getMetaData() method on a database connection returns meta data information about the connected database server.
Meta data includes information about the database server product, the JDBC driver, and the current user.
Meta data also includes information about the schema, tables, columns, procedures, and functions.