clickhouse - show语句

 

1.显示创建表show create table

SHOW CREATE [TEMPORARY] [TABLE|DICTIONARY] [db.]table [INTO OUTFILE filename] [FORMAT format]

2.显示数据库

SHOW DATABASES [LIKE | ILIKE | NOT LIKE '<pattern>'] [LIMIT <N>] [INTO OUTFILE filename] [FORMAT format]

3.显示流程清单

SHOW PROCESSLIST [INTO OUTFILE filename] [FORMAT format]

4.显示表列表

SHOW [TEMPORARY] TABLES [{FROM | IN} <db>] [LIKE | ILIKE | NOT LIKE '<pattern>'] [LIMIT <N>] [INTO OUTFILE <filename>] [FORMAT <format>]

如果FROM未指定该子句，则查询从当前数据库返回表列表。

SHOW TABLES FROM system ILIKE '%USER%';

SHOW TABLES FROM system NOT LIKE '%s%';

SHOW TABLES FROM system LIMIT 2;

5.显示词典

SHOW DICTIONARIES [FROM <db>] [LIKE '<pattern>'] [LIMIT <N>] [INTO OUTFILE <filename>] [FORMAT <format>]

如果FROM未指定该子句，则查询从当前数据库返回字典列表。

SHOW DICTIONARIES FROM db LIKE '%reg%' LIMIT 2;

6.显示授权

SHOW GRANTS [FOR user1 [, user2 ...]]

如果未指定用户，则查询返回当前用户的特权。

 

待续。。。。。。