The 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.
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.
- Paul C. Tinnirello (1999). Systems Development Handbook. CRC Press. ISBN 0-8493-9822-3.
- CREATE VIEW (Transact-SQL) in SQL Server 2008 Books Online, Microsoft Corporation
DBMS catalog stores the description of the database. The description is called meta-data). This allows the DBMS software to work with different databases.
|This database-related article is a stub. You can help Wikipedia by expanding it.|
Read in another language
This page is available in 1 language