v.21.11New Features
Added INFORMATION_SCHEMA Database with SCHEMATA, TABLES, VIEWS, and COLUMNS Views to System Database
AddedINFORMATION_SCHEMAdatabase withSCHEMATA,TABLES,VIEWSandCOLUMNSviews to the corresponding tables insystemdatabase. Closes #9770. #28691 (tavplubix).
Why it matters
This feature provides a standardized way to query database metadata using the widely adoptedINFORMATION_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 theINFORMATION_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.