SQL/Schemata

The SQL/Schemata, or Information and Definition Schemas, part to 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, structure and integrity constraints, security and authorization specifications, features and packages of ISO/IEC 9075, support of features provided by SQL-based DBMS implementations, SQL-based DBMS implementation information and sizing items, and the values supported by the DBMS implementations.^[1] SQL/Schemata defines a number of features, some of which are mandatory.

References

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

External links

SQL

Versions	SQL-86 SQL-89 SQL-92 SQL:1999 SQL:2003 SQL:2006 SQL:2008 SQL:2011

Keywords	As Case Create Delete From Having Insert Join Merge Null Order by Prepare Select Truncate Union Update Where With

Related	Edgar Codd Relational database

ISO/IEC SQL parts	Framework Foundation Call-Level Interface Persistent Stored Modules Management of External Data Object Language Bindings Information and Definition Schemas SQL Routines and Types for the Java Programming Language XML-Related Specifications

This article is issued from Wikipedia - version of the Sunday, March 17, 2013. The text is available under the Creative Commons Attribution/Share Alike but additional terms may apply for the media files.

SQL/Schemata

See also

References

External links