What is DatabaseMetaData in Java?

What is DatabaseMetaData?

DatabaseMetaData provides comprehensive information about the database. This interface is implemented by the driver vendors to allow the user to obtain information about the tables of a relational database as a part of JDBC application. User can use this interface to deal with various underlying DBMSs. Some of the methods are:

getDatabaseMajorVersion(), getDatabaseMinorVersion(), getDatabaseProductName(), getDatabaseProductVersion(), getMaxRowSize(), getPrimaryKeys(), getURL(), getUserName() etc.

public interface DatabaseMetaData
This interface is implemented by driver vendors.
It lets users know the capabilities of a Database Management System (DBMS) in combination with the JDBC driver that is used with it.
What is ResultSetMetaData in Java?
ResultSetMetaData is a class which provides information about a result set that is returned by an executeQuery() method...
CacheRowset, JDBCRowset and WebRowset in Java.
A CacheRowSet object is a container for rows, that ‘caches’ the rows in the memory...
Different types of locks in JDBC
A lock is a preventive software mechanism that other users can not use the data resource...
Post your comment