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
anddate
are both valid.alias_to
(String) β Data type name for whichname
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.