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?

user_1032117 · Answer

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

user_1204665 · Answer

You can also use

SELECT engine_full FROM system.tables;