Skip to main content

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

SELECT * FROM system.data_type_families WHERE alias_to = 'String'
β”Œβ”€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 β”‚
β””β”€β”€β”€β”€β”€β”€β”€β”€β”€β”€β”€β”€β”΄β”€β”€β”€β”€β”€β”€β”€β”€β”€β”€β”€β”€β”€β”€β”€β”€β”€β”€β”΄β”€β”€β”€β”€β”€β”€β”€β”€β”€β”€β”˜

See Also

  • Syntax β€” Information about supported syntax.

Original article