Add an information_schema.indexes view.
We expose information_schema.tables and .columns. Add .indexes listing every index: table_name, index_name, column_name, is_primary.
Where
- Wherever the existing
information_schema tables are synthesized (search information_schema in v2/src/).
- Index metadata lives on
Table in v2/src/storage.h (PK col + SecondaryIndex list).
Acceptance criteria
SELECT * FROM information_schema.indexes lists the PK and every CREATE INDEX.- It appears in the Workbench sidebar's system section.
See CONTRIBUTING.md and comment here to claim it.
Add an
information_schema.indexesview.We expose
information_schema.tablesand.columns. Add.indexeslisting every index:table_name, index_name, column_name, is_primary.Where
information_schematables are synthesized (searchinformation_schemainv2/src/).Tableinv2/src/storage.h(PK col +SecondaryIndexlist).Acceptance criteria
SELECT * FROM information_schema.indexeslists the PK and everyCREATE INDEX.See CONTRIBUTING.md and comment here to claim it.