v.24.6Improvement

SHOW CREATE TABLE Enhancements with Unique Comments for System Tables

Official CH changelog text
SHOW CREATE TABLE executed on top of system tables will now show the super handy comment unique for each table which will explain why this table is needed. #63788 (Nikita Mikhaylov).
SHOW CREATE TABLE on system tables now includes a unique comment explaining the purpose of each table.

Why it matters

This feature improves the usability and clarity of system tables by adding descriptive comments to the output of SHOW CREATE TABLE. It helps users understand the role and necessity of each system table without external references.

How to use it

Simply execute SHOW CREATE TABLE [system_table_name] on any system table. The output will contain a comment describing why the table exists.

Related resources

PreviousNext