metamodel-dev mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From Ashuthosh Bhat <techie.ab...@googlemail.com>
Subject Re: Reading Indexes created in a DB
Date Wed, 02 Aug 2017 13:48:57 GMT
Thanks for quick revert Dennis.

Can code contribution towards retrieval/creation of indexes be considered?

Thanks,
Ashu

On Wed, Aug 2, 2017 at 12:57 PM, Dennis Du Kr√łger <
Dennis.DuKroger@humaninference.com> wrote:

> 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.abhat@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
>

Mime
  • Unnamed multipart/alternative (inline, None, 0 bytes)
View raw message