Jump to content

Database catalog

From Wikipedia, the free encyclopedia

This is the current revision of this page, as edited by Adhiyana (talk | contribs) at 15:01, 23 January 2022 (#suggestededit-add 1.0). The present address (URL) is a permanent link to this version.

(diff) ← Previous revision | Latest revision (diff) | Newer revision → (diff)

A database catalog of a database instance consists of metadata in which definitions of database objects such as base tables, views (virtual tables), synonyms, value ranges, indexes, users, and user groups are stored.[1][2]

The SQL standard specifies a uniform means to access the catalog, called the INFORMATION_SCHEMA, but not all databases follow this, even if they implement other aspects of the SQL standard. For an example of database-specific metadata access methods, see Oracle metadata.

See also[edit]

References[edit]

  1. ^ Paul C. Tinnirello (1999). Systems Development Handbook. CRC Press. ISBN 0-8493-9822-3.
  2. ^ CREATE VIEW (Transact-SQL) in SQL Server 2008 Books Online, Microsoft Corporation