Can I find the Sorting key/OrderBy key or other creation time properties of already created Table in Clickhouse?

Question

Can I find the Sorting key i.e. Order BY key or Primary Key used at a time of Table creation in Clickhouse? Same goes for if I want to find the Table Engine used for creation, How can I find it?

Answer 1

You can use system.tables

SELECT
    sorting_key,
    engine_full
FROM system.tables
WHERE (database = '<database_name>') AND (name = '<table_name>')