> ## 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 containing information about supported data types

# system.data_type_families

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

Contains information about supported [data types](/reference/data-types/index).

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

* `name` ([String](/reference/data-types/index)) — Data type name.
* `case_insensitive` ([UInt8](/reference/data-types/index)) — Property that shows whether you can use a data type name in a query in case insensitive manner or not. For example, `Date` and `date` are both valid.
* `alias_to` ([String](/reference/data-types/index)) — Data type name for which `name` is an alias.
* `description` ([String](/reference/data-types/index)) — A high-level description of what the data type is.
* `syntax` ([String](/reference/data-types/index)) — How the data type is spelled in a query.
* `examples` ([String](/reference/data-types/index)) — Usage examples.
* `introduced_in` ([String](/reference/data-types/index)) — The ClickHouse version in which the data type was first introduced, in the form major.minor.
* `related` ([Array(String)](/reference/data-types/index)) — The names of related data types.

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

```sql theme={null}
SELECT name, case_insensitive, alias_to FROM system.data_type_families WHERE alias_to = 'String'
```

```text theme={null}
┌─name───────┬─case_insensitive─┬─alias_to─┐
│ LONGBLOB   │                1 │ String   │
│ LONGTEXT   │                1 │ String   │
│ TINYTEXT   │                1 │ String   │
│ TEXT       │                1 │ String   │
│ VARCHAR    │                1 │ String   │
│ MEDIUMBLOB │                1 │ String   │
│ BLOB       │                1 │ String   │
│ TINYBLOB   │                1 │ String   │
│ CHAR       │                1 │ String   │
│ MEDIUMTEXT │                1 │ String   │
└────────────┴──────────────────┴──────────┘
```

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

* [Syntax](/reference/syntax) — Information about supported syntax.