is there sys table where index names kept
KARL OLIVER asked where index names are stored on IDS 11.50.UC9. Art Kagel said sysindices holds them in each database, with the sysindexes view easier for simple indexes, and mentioned print_indexes.ec in myschema from utils2_ak. Lloyd S suggested select idxname, owner from sysindexes. Karl thanked them.
Auto-generated by Claude from the posts below — may be imperfect; read the full thread.
IBM Informix Dynamic Server Version 11.50.UC9 Software Serial Number AAA#B00000 is there are table where index names are kept. in the sysmaster db or anywjhere else
Index details are kept in the sysindices catalog table in each database. There is also a view (sysindexes) which is easier to parse for simple indexes (ie not functional indexes). The index name is in the idxname column. For full details of decoding sysindices directly take at look at the file print_indexes.ec in the source code for myschema which is part of my package utils2_ak from the IIUG Software Repository. Art Art S. Kagel, Principal Consultant Advanced DataTools (www.advancedatatools.com) Blog: http://informix-myview.blogspot.com/ Disclaimer: Please keep in mind that my own opinions are my own opinions and do not reflect on my employer, Advanced DataTools, the IIUG, nor any other organization with which I am associated either explicitly, implicitly, or by inference. Neither do those opinions reflect those of other individuals affiliated with any entity with which I am affiliated nor those of the entities themselves. On Sun, Sep 22, 2013 at 9:59 PM, KARL OLIVER <karl.oliver@maf.govt.nz>wrote: > IBM Informix Dynamic Server Version 11.50.UC9 Software Serial Number > AAA#B00000 > > is there are table where index names are kept. in the sysmaster db or > anywjhere else > > > > ******************************************************************************* > Forum Note: Use "Reply" to post a response in the discussion forum. > > --001a11c34e6ca73f0a04e704cd07
Karl,
sysindexes table within your database.
select idxname, owner from sysindexes
Regards,Lloyd
From: "KARL OLIVER" <karl.oliver@maf.govt.nz>
Sent: Mon, 23 Sep 2013 07:29:26
To: ids@iiug.org
Subject: is there sys table where index names kept [31475]
IBM Informix Dynamic Server Version 11.50.UC9 Software Serial Number
AAA#B00000
is there are table where index names are kept. in the sysmaster db or
anywjhere else
*******************************************************************************
Forum Note: Use "Reply" to post a response in the discussion forum.
thanks for infor guys