v.25.8Improvement

System.columns table now provides column as

The system.columns table now provides column as an alias for the existing name column. #84695 (Yunchi Pang).
The system.columns table now includes column as an alias for the existing name column.

Why it matters

This feature improves the readability and usability of the system.columns table by providing a more intuitive alias, column, for the name column. It helps users better understand the data structure and aligns with common terminology when referring to column names.

How to use it

Users can query the system.columns table using either column or name to retrieve column names. For example:

SELECT column, type FROM system.columns WHERE table = 'your_table'