Jump to content

SQL/Schemata

From Wikipedia, the free encyclopedia
The printable version is no longer supported and may have rendering errors. Please update your browser bookmarks and please use the default browser print function instead.

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

References

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