v.23.5New Feature

Support SHOW INDEX for MySQL Compatibility

Official CH changelog text
Support statement SHOW INDEX to improve compatibility with MySQL. #49158 (Robert Schulze).
Support for the SHOW INDEX statement has been added to ClickHouse to improve compatibility with MySQL.

Why it matters

This feature addresses the need for better MySQL compatibility by allowing users to retrieve index information using the familiar SHOW INDEX statement. It helps users migrating from MySQL or integrating systems that rely on this command to view index details in ClickHouse.

How to use it

Users can run the SHOW INDEX FROM <table_name> command in ClickHouse to display index information for a specified table, similar to how it works in MySQL.

Related resources

PreviousNext