Hi Ashu, Most information from SQL databases can be gathered using the INFORMATION_SCHEMA schema. Unfortunately, indexes isn't one of them, so you'll need to see if there are some something specific for each database.
E.g. for SQL Server you can query sys.indexes to get a list of all indexes. To get the tables the indexes belongs to, you need to join sys.tables on the object ID I believe something similar is available for most databases. But it's of course quite a bit more involved than just getting a list of indexes. Best regards, Dennis ________________________________ From: Ashuthosh Bhat <techie.ab...@googlemail.com> Sent: 02 August 2017 08:40:12 To: dev@metamodel.apache.org Subject: Reading Indexes created in a DB Dear all, I am trying to read indexes created on various tables in a DB. Is this feature available in metamodel. I could not find the same. Checked tabletypes as well there is no type as index. Please suggest. Thanks, Ashu
