SQL/Schemata

From Wikipedia, the free encyclopedia

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[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

  1. ↑ 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. The text is available under the Creative Commons Attribution/Share Alike; additional terms may apply for the media files.