Clickhouse: how to find indexed field in clickhouse SQL?

Question

I have existing table in ClickHouse. I want to find which field is an index field. How do I do it?

score 8 · Accepted Answer · answered Sep 17 '18 at 06:50

8

You can use SHOW CREATE TABLE my_table; to see the primary key (index) and other settings.

answered Sep 17 '18 at 06:50

Ivan Blinkov

score 3 · Answer 2 · answered Sep 18 '18 at 08:27

3

You can also use

SELECT engine_full FROM system.tables;

answered Sep 18 '18 at 08:27

Slach

2 Answers2