SQL/Schemata
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 databases and objects self-describing. These tools include the {{clarify span|SQL object identifier|date=December 2012}}, {{clarify span|structure|date=December 2012}} and integrity constraints, {{clarify span|security and authorization specifications|date=December 2012}}, features and {{clarify span|packages|date=December 2012}} of ISO/IEC 9075, support of features provided by SQL-based DBMS implementations, SQL-based DBMS implementation information and {{clarify span|sizing items|date=December 2012}}, and the {{clarify span|values supported|date=December 2012}} by the DBMS implementations.{{Citation
| title = ISO/IEC 9075-11:2008: Information and Definition Schemas (SQL/Schemata)
| pages = 1
| year = 2008
}} 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