by, 03-09-2012 at 07:30 PM (915 Views)
Users and database information is stored itself in databases. Majority of DBMS consist of s set of system tables, which lists:
- Tables in the database
- Primary keys
- Foreign keys
- Column names in each table
- Stored procedures
Database features and table layout information is obtained by DBMS which consists of its own functions. Interface DatabaseMetaData is provided by the JDBC that shall be implemented by a driver writer. This is done information regarding DBMS or driver is returned. E.g. many methods return no matter driver provides a particular functionality or not. In this way a standardized method is given to tools and user by interface to get metadata.