The SQL/Schemata, or ''Information and Definition Schemas'', part of the
SQL standard is defined by
ISO/IEC 9075-11:2008. SQL/Schemata defines the
information schema and
definition schema, providing a common set of tools to make SQL
database
In computing, a database is an organized collection of data stored and accessed electronically. Small databases can be stored on a file system, while large databases are hosted on computer clusters or cloud storage. The design of databases s ...
s and objects self-describing. These tools include the , and
integrity constraints
Data integrity is the maintenance of, and the assurance of, data accuracy and consistency over its entire life-cycle and is a critical aspect to the design, implementation, and usage of any system that stores, processes, or retrieves data. The ter ...
, , features and of
ISO/IEC 9075, support of features provided by SQL-based
DBMS
In computing, a database is an organized collection of data stored and accessed electronically. Small databases can be stored on a file system, while large databases are hosted on computer clusters or cloud storage. The design of databases s ...
implementations, SQL-based DBMS implementation information and , and the by the DBMS implementations.
SQL/Schemata defines a number of features, some of which are mandatory.
See also
*
Data Definition Language (CREATE, ALTER, DROP...)
*
SQL:2003 (Introduced SQL/Schemata)
*
Data dictionary
A data dictionary, or metadata repository, as defined in the ''IBM Dictionary of Computing'', is a "centralized repository of information about data such as meaning, relationships to other data, origin, usage, and format". ''Oracle'' defines it ...
References
External links
SQL
{{database-stub