Misplaced Pages

Database catalog

Article snapshot taken from Wikipedia with creative commons attribution-sharealike license. Give it a read and then ask your questions in the chat. We can research this topic together.
Document with definitions of database objects such as base tables, views, synonyms and value ranges

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. It is an architecture product that documents the database's content and data quality.

Standards

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

References

  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
  3. "Databasekatalog | QualiWare Center of Excellence". Retrieved 2024-09-28.
Stub icon

This database-related article is a stub. You can help Misplaced Pages by expanding it.

Categories: