v.21.11New Features

Added INFORMATION_SCHEMA Database with SCHEMATA, TABLES, VIEWS, and COLUMNS Views to System Database

Added INFORMATION_SCHEMA database with SCHEMATA, TABLES, VIEWS and COLUMNS views to the corresponding tables in system database. Closes #9770. #28691 (tavplubix).
Added the INFORMATION_SCHEMA database with SCHEMATA, TABLES, VIEWS, and COLUMNS views that expose metadata from the ClickHouse system database.

Why it matters

This feature provides a standardized way to query database metadata using the widely adopted INFORMATION_SCHEMA convention, simplifying access to schema information for users and tools that expect this format. It improves compatibility and usability by offering a familiar interface for exploring database objects.

How to use it

Users can query the INFORMATION_SCHEMA database directly to retrieve metadata information. For example, to list tables, run:

SELECT * FROM INFORMATION_SCHEMA.TABLES;

No additional configuration or setup is required as the views map to existing system tables.