What is Metadata and why should I use it?

Lennart Jorelid

Metadata ('data about data') is information about one of two things:

  1. Database information (java.sql.DatabaseMetaData), or
  2. Information about a specific ResultSet (java.sql.ResultSetMetaData).

Use DatabaseMetaData to find information about your database, such as its capabilities and structure. Use ResultSetMetaData to find information about the results of an SQL query, such as size and types of columns.

See "Database Metadata Example" and "ResultSet Metadata Example"