{
  "id": "enwiki-001357522697",
  "slug": "information-schema",
  "title": "Information schema",
  "qid": "",
  "lead": "In relational databases, the 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)",
  "body": "In relational databases, the 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). 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)",
  "categories": [
    "20326113",
    "20549174",
    "22926642",
    "22985424",
    "23118434",
    "23468805",
    "23603337",
    "24737925",
    "90215689"
  ],
  "license": "CC BY-SA 4.0",
  "source_uri": "https://en.wikipedia.org/w/index.php?oldid=1357522697",
  "content_hash": "",
  "created_at": null,
  "updated_at": 1780449803.0,
  "claims": [],
  "contradictions": [],
  "confidence": 0.6,
  "csl": {
    "id": "enwiki-001357522697",
    "type": "webpage",
    "title": "Information schema",
    "author": [
      {
        "family": "Anticloud FZ LLE",
        "literal": "Anticloud FZ LLE"
      }
    ],
    "container-title": "encyclopegia.org",
    "publisher": "Anticloud FZ LLE",
    "publisher-place": "Dubai, United Arab Emirates",
    "URL": "https://encyclopegia.org/a/information-schema",
    "issued": {
      "date-parts": [
        [
          2026,
          11,
          16
        ]
      ]
    },
    "accessed": {
      "date-parts": [
        [
          2026,
          11,
          16
        ]
      ]
    },
    "license": "CC BY-SA 4.0",
    "DOI": "eo1:enwiki-001357522697",
    "isBasedOn": "https://en.wikipedia.org/w/index.php?oldid=1357522697",
    "note": "Immutable snapshot enwiki-001357522697"
  }
}