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 SQL object identifier[ clarify], structure[ clarify] and integrity constraints, security and authorization specifications[ clarify], features and packages[ clarify] of ISO/IEC 9075, support of features provided by SQL-based DBMS implementations, SQL-based DBMS implementation information and sizing items[ clarify], and the values supported[ clarify] by the DBMS implementations. [1] 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
References
- ^ ISO/IEC 9075-11:2008: Information and Definition Schemas (SQL/Schemata), 2008, p. 1
External links
 | This database-related article is a stub. You can help Wikipedia by expanding it. |
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 SQL object identifier[ clarify], structure[ clarify] and integrity constraints, security and authorization specifications[ clarify], features and packages[ clarify] of ISO/IEC 9075, support of features provided by SQL-based DBMS implementations, SQL-based DBMS implementation information and sizing items[ clarify], and the values supported[ clarify] by the DBMS implementations. [1] 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
References
- ^ ISO/IEC 9075-11:2008: Information and Definition Schemas (SQL/Schemata), 2008, p. 1
External links
|
| This database-related article is a stub. You can help Wikipedia by expanding it. |