Function to get Table indices

[Former Member]

Dear all,

i'm looking for a function modul to get indices of individuell table.

I could'nt dfinde any one!

best regards

[vinod_vemuru2]

Hi,

I you can check the table DD12L for INDEX definitions of a table and DD12T for descriptions of indexes. Here pass the table name

Thanks,

Vinod.

[former_member194416]

Hi,

You can use FM " DB_GET_INDEXES'.

Regards,

[Former Member]

Thank you very very much to all

ehmm @Gungor Ozcelebi

I get now all index fields from the FM. How can I determine the secondary indices.

I think its everything fields without '~0' right?

best regards

Edited by: handeglo on Jan 4, 2010 2:53 PM

[Former Member]

you get the following tables in the FM.. right?

DBINDEXES

DBINDFLDS

in this DBINDEXES you have 1 field for index another for unique.. for primary key it would be 'X'.

or any ways the index <tab_name>~0 means primary key( ~0).

after getting this...

you delete the lines for <tab_name>~0 from DBINDFLDS and rest are your secondary keys

[Former Member]

Yes, that's

Thank you again !

best regards

[Clemenss]

yes, ~0 is allways the primary index, all others are secondary.

Regards,

Clemens

[Former Member]

Hello

DD12L, DD12T, DD12V