indexes of a table with jdbc

Posted in 2000

Topics: SQL Development & Query Writing, Connectivity: ODBC / JDBC / .NET, Java & JDBC Development

J�rgen Messer — Wed, 10 May 2000 14:05:12 +0200 — source: Informix-list mailing list archive (1991-1998)

Hi, I've to find out all the indexes of a table from a Java client. All the tables in a database I can get with a select statement "select * from sysmaster where dbsname="xx"". Is there any possibility to get the indexes in an easy way? Thanks for any hints and tips, best regards, Juergen Messer

↪ replying to J�rgen Messer

mars1972@my-deja.com — Wed, 10 May 2000 13:13:19 GMT — source: Informix-list mailing list archive (1991-1998)

select idxname from sysindexes... ... ... There's a table called sysmaster? In article <8fbj5e$ach6b$1@fu-berlin.de>, "J'rgen Messer" <messer@dpd.de> wrote: > Hi, > > I've to find out all the indexes of a table from a Java client. All the > tables in a database I can get with a select statement "select * from > sysmaster where dbsname="xx"". Is there any possibility to get the indexes > in an easy way? > > Thanks for any hints and tips, > > best regards, > > Juergen Messer > > -- # unrm / ksh: unrm: not found # man cpio Sent via Deja.com http://www.deja.com/ Before you buy.