v.22.7Improvement

Support SQL CREATE INDEX and DROP INDEX Syntax

Official CH changelog text
Support SQL standard CREATE INDEX and DROP INDEX syntax. #35166 (Jianmei Zhang).
Support for SQL standard CREATE INDEX and DROP INDEX syntax in ClickHouse.

Why it matters

This feature introduces native support for the standard SQL syntax to create and drop indexes. It simplifies index management by allowing users to use familiar CREATE INDEX and DROP INDEX commands, improving usability and compatibility with standard SQL practices.

How to use it

Users can create indexes using the standard SQL syntax:

CREATE INDEX index_name ON table_name (column_name);


and drop indexes using:

DROP INDEX index_name ON table_name;


This allows easier integration of ClickHouse with tools and workflows expecting standard SQL index definitions.**

Related resources

PreviousNext