Re: Tabnames

Posted in 1999

Obnoxio The Clown — Wed, 07 Jul 1999 06:59:53 GMT — source: Informix-list mailing list archive (1991-1998)

From: Peter Sloboda <petersloboda@earthlink.net> >anyone idea, how to retrieve the names of the tables for specific ><db_name>? >I ran : > >database sysmaster; >select tabname from systabnames where dbsname=<db_name>;> >but I got the names of the indexes too. Oh? I tried this for several databases and I couldn't repeat that behaviour. FWIW. ______________________________________________________ Get Your Private, Free Email at http://www.hotmail.com

↪ replying to Obnoxio The Clown

Art S. Kagel — Thu, 08 Jul 1999 11:59:47 -0400 — source: Informix-list mailing list archive (1991-1998)

Obnoxio The Clown wrote: > > From: Peter Sloboda <petersloboda@earthlink.net> > > >anyone idea, how to retrieve the names of the tables for specific > ><db_name>? > >I ran : > > > >database sysmaster; > >select tabname from systabnames where dbsname=<db_name>;> > > >but I got the names of the indexes too. > > Oh? I tried this for several databases and I couldn't repeat that behaviour. Because you have no detached indexes (or post 7.21 fragmented tables with indexes). These show up as separate tables in systabnames. Art S. Kagel