SQL - Schema

> (Data|State) Management and Processing > (Data Type|Data Structure) > (Relation|Table) - Tabular data > Structured Query Language (SQL)

1 - About

An SQL-schema, often referred to simply as a schema, is a persistent, named collection of descriptors.

Most providers have a limited number of levels; for example, most databases have either;

  • one level (“schemas”)
  • or two levels (“database” and “catalog”).

3 - Information Schema

Information_schema is an ANSI-standard set of read-only views which provide information about