Help wanted!
The following content of this documentation page has been machine-translated. But unlike other websites, it is not done on the fly. This translated text lives on GitHub repository alongside main ClickHouse codebase and waits for fellow native speakers to make it more human-readable. You can also use the original English version as a reference.
系统。data_type_families
包含有关受支持的信息 数据类型.
列:
name
(字符串) — 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
和date
都是有效的。alias_to
(字符串) — Data type name for whichname
是个化名
示例
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 │
└────────────┴──────────────────┴──────────┘
另请参阅
- 语法 — Information about supported syntax.