Can I find the Sorting key/OrderBy key or other creation time properties of already created Table in Clickhouse?
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?
You can use system.tables
SELECT
sorting_key,
engine_full
FROM system.tables
WHERE (database = '<database_name>') AND (name = '<table_name>')