v.23.4New Feature

Add SHOW COLUMNS Statement to Display Distilled Information from system.columns

Add a statement SHOW COLUMNS which shows distilled information from system.columns. #48017 (Robert Schulze).
Introduce the SHOW COLUMNS statement to display distilled column information from system.columns.

Why it matters

The feature provides users with a simple and convenient way to retrieve detailed metadata about table columns without querying the system.columns table directly, improving usability and efficiency when inspecting table schemas.

How to use it

Users can execute the statement:

SHOW COLUMNS FROM <table_name>


to retrieve a concise list of columns and their metadata for the specified table.