View RSS Feed

Java Database

SQL Metadata

Rate this Entry
by , 03-09-2012 at 07:30 PM (991 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.

Submit "SQL Metadata" to Facebook Submit "SQL Metadata" to Digg Submit "SQL Metadata" to del.icio.us Submit "SQL Metadata" to StumbleUpon Submit "SQL Metadata" to Google

Tags: sql metadata Add / Edit Tags
Categories
SQL

Comments