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).Why it matters
The feature provides users with a simple and convenient way to retrieve detailed metadata about table columns without querying thesystem.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.