system.data_type_families

Contains information about supported data types.

Columns:

  • name (String) — Data type name.
  • case_insensitive (UInt8) — 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) — Data type name for which name is an alias.

Example

  1. SELECT * FROM system.data_type_families WHERE alias_to = 'String'
  1. ┌─name───────┬─case_insensitive─┬─alias_to─┐
  2. │ LONGBLOB   │                1 │ String   │
  3. │ LONGTEXT   │                1 │ String   │
  4. │ TINYTEXT   │                1 │ String   │
  5. │ TEXT       │                1 │ String   │
  6. │ VARCHAR    │                1 │ String   │
  7. │ MEDIUMBLOB │                1 │ String   │
  8. │ BLOB       │                1 │ String   │
  9. │ TINYBLOB   │                1 │ String   │
  10. │ CHAR       │                1 │ String   │
  11. │ MEDIUMTEXT │                1 │ String   │
  12. └────────────┴──────────────────┴──────────┘

See Also

  • Syntax — Information about supported syntax.

Original article