> ## Documentation Index
> Fetch the complete documentation index at: https://private-7c7dfe99-fix-nav-issues.mintlify.site/llms.txt
> Use this file to discover all available pages before exploring further.

> System table that collects the embedded documentation of the uniform components of the system (functions, table engines, data types, and so on) into a single table, with the reference documentation rendered as Markdown.

# system.documentation

<h2 id="description">
  Description
</h2>

Collects the embedded documentation of the uniform components of the system into a single table. Every row corresponds to one entity (a function, a table engine, a data type, and so on) and contains the reference documentation of that entity rendered as Markdown — the same content that is published on the website and exposed by the per-kind `system.*` tables.

The `description` is assembled from the structured parts of the embedded documentation (`description`, `syntax`, arguments, examples, and so on), so a single column holds the complete documentation of an entity. Aliases are rendered as a short reference to the canonical entity, e.g. ``Alias of `trunc`.``

This table, in a certain way, collects the information available in the per-kind documentation tables ([`system.functions`](/reference/system-tables/functions), [`system.table_engines`](/reference/system-tables/table_engines), [`system.data_type_families`](/reference/system-tables/data_type_families), and others). It is meant, in particular, to back an interactive `help` command in the client, but is useful on its own.

The following kinds of entities are collected (the value of the `type` column is shown in parentheses):

* Functions (`Function`)
* Aggregate functions (`Aggregate Function`)
* Table functions (`Table Function`)
* Table engines (`Table Engine`)
* Database engines (`Database Engine`)
* Data types (`Data Type`)
* Dictionary layouts (`Dictionary Layout`)
* Dictionary sources (`Dictionary Source`)
* Aggregate function combinators (`Aggregate Function Combinator`)
* Data skipping index types (`Data Skipping Index`)
* Disk types (`Disk Type`)
* Settings (`Setting`)
* MergeTree settings (`MergeTree Setting`)
* Server settings (`Server Setting`)
* Formats (`Format`)

For settings, the documentation is the setting's description; obsolete settings are not exposed.

<h2 id="columns">
  Columns
</h2>

* `name` ([String](/reference/data-types/index)) — The name of the entity, e.g. `domainWithoutWWW` or `MergeTree`.
* `type` ([Enum8('Function' = 1, 'Aggregate Function' = 2, 'Table Function' = 3, 'Table Engine' = 4, 'Database Engine' = 5, 'Data Type' = 6, 'Dictionary Layout' = 7, 'Dictionary Source' = 8, 'Aggregate Function Combinator' = 9, 'Data Skipping Index' = 10, 'Disk Type' = 11, 'Setting' = 12, 'MergeTree Setting' = 13, 'Server Setting' = 14, 'Format' = 15)](/reference/data-types/index)) — The kind of the entity, e.g. `Function` or `Table Engine`.
* `description` ([String](/reference/data-types/index)) — The reference documentation of the entity rendered as Markdown, assembled from the embedded documentation (the same content as published on the website), including syntax, examples and other structured parts, if any.

<h2 id="example">
  Example
</h2>

Read the documentation of a particular entity:

```sql title="Query" theme={null}
SELECT description
FROM system.documentation
WHERE type = 'Table Engine' AND name = 'MergeTree'
FORMAT TSVRaw;
```

The same name can refer to several kinds of entities (for example, there is both a `file` table function and a `file` dictionary source), so it is convenient to look a name up across all kinds:

```sql title="Query" theme={null}
SELECT type, name
FROM system.documentation
WHERE name = 'file'
ORDER BY type;
```

Count the documented entities of each kind:

```sql title="Query" theme={null}
SELECT type, count()
FROM system.documentation
GROUP BY type
ORDER BY count() DESC;
```

<h2 id="see-also">
  See also
</h2>

* [`system.functions`](/reference/system-tables/functions) — Regular and aggregate functions.
* [`system.table_functions`](/reference/system-tables/table_functions) — Table functions.
* [`system.table_engines`](/reference/system-tables/table_engines) — Table engines.
* [`system.database_engines`](/reference/system-tables/database_engines) — Database engines.
* [`system.data_type_families`](/reference/system-tables/data_type_families) — Data types.
* [`system.disk_types`](/reference/system-tables/disk_types) — Disk types.
* [`system.settings`](/reference/system-tables/settings) — Settings.
* [`system.merge_tree_settings`](/reference/system-tables/merge_tree_settings) — MergeTree settings.
* [`system.server_settings`](/reference/system-tables/server_settings) — Server settings.
* [`system.formats`](/reference/system-tables/formats) — Formats.