Jump to content

SQL/Schemata

From Wikipedia, the free encyclopedia
This is the current revision of this page, as edited by 38.81.112.2 (talk) at 15:43, 25 June 2019. The present address (URL) is a permanent link to this version.
(diff) ← Previous revision | Latest revision (diff) | Newer revision → (diff)

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

[edit]

References

[edit]
  1. ^ ISO/IEC 9075-11:2008: Information and Definition Schemas (SQL/Schemata), 2008, p. 1
[edit]