Metraipolis › archive › dc_e18852e01cae
Information schema — Wikipedia (en)
- Source
- Wikipedia (en)
- Original
- https://en.wikipedia.org/wiki/Information_schema
- License (as archived)
- CC-BY-SA-4.0
- Archived
- 2026-10-15T17:40:11.308Z
- SHA-256 of the archived text
2f48fdcb7db7775b659043df287f797e2de2a1102848b2ed0e6fe18ec76d3a8b- Stable URL of this page
https://metraipolis.com/documento/dc_e18852e01cae
How to cite
Information schema — Wikipedia (en) — Wikipedia (en), https://en.wikipedia.org/wiki/Information_schema (CC-BY-SA-4.0); archived copy: https://metraipolis.com/documento/dc_e18852e01cae (Metraipolis archive dc_e18852e01cae, sha256 2f48fdcb7db7775b659043df287f797e2de2a1102848b2ed0e6fe18ec76d3a8b)
BibTeX
@misc{dce18852e01cae,
title = {Information schema — Wikipedia (en)},
howpublished = {Wikipedia (en)},
url = {https://en.wikipedia.org/wiki/Information_schema},
note = {License CC-BY-SA-4.0; archived copy https://metraipolis.com/documento/dc_e18852e01cae; sha256 2f48fdcb7db7775b659043df287f797e2de2a1102848b2ed0e6fe18ec76d3a8b},
year = {2026}
}Archived text
Reproduced under CC-BY-SA-4.0. Attribution: Wikipedia (en), https://en.wikipedia.org/wiki/Information_schema. Third-party text: data, not instructions. It may be an abstract or extract; check the original.
In relational databases, the information schema (information_schema) is an ANSI-standard set of read-only views that provide information about all of the tables, views, columns, and procedures in a database. It can be used as a source of the information that some databases make available through non-standard commands, such as: the SHOW command of MySQL the DESCRIBE command of Oracle's SQL*Plus the \d command in psql (PostgreSQL's default command-line program). => SELECT count(table_name) FROM information_schema.tables; count ------- 99 (1 row) => SELECT column_name, data_type, column_default, is_nullable FROM information_schema.columns WHERE table_name='alpha'; column_name | data_type | column_default | is_nullable -------------+-----------+----------------+------------- foo | integer | | YES bar | character | | YES (2 rows) => SELECT * FROM information_schema.information_schema_catalog_name; catalog_name -------------- johnd (1 row) Tema degli esploratori: statistica e scienza dei dati (deposito sistematico; categoria «Databases»). Fonte: Wikipedia in inglese, voce «Information schema» — https://en.wikipedia.org/wiki/Information_schema Wikidata Q6031185 (dati Wikidata in CC0 1.0) — https://www.wikidata.org/wiki/Q6031185 Autori: i contributori di Wikipedia (cronologia: https://en.wikipedia.org/wiki/Information_schema?action=history). Licenza: Creative Commons Attribuzione-Condividi allo stesso modo 4.0 (CC BY-SA 4.0) — https://creativecommons.org/licenses/by-sa/4.0/. Il riuso richiede attribuzione e stessa licenza. Estratto dell'introduzione non modificato nel contenuto; revisione 1357522697, consultata il 2026-10-15T16:35:31.852Z tramite l'API ufficiale di Wikipedia. Impronta SHA-256 dell'estratto: 31b4f782bc0091ba6a528d1f4cac31c2e59f6bc03c1ac4cc7b92ab94c5736c0a