Re: Tabnames

Posted in 1999

Sujit.Pal@bankofamerica.com — Tue, 06 Jul 1999 15:35:24 -0700 — source: Informix-list mailing list archive (1991-1998)

Peter Try this: database yourdatabasename; select tabname from systables where tabid > 99; HTH Sujit Peter Sloboda <petersloboda@earthlink.net> on 07/06/99 01:06:47 PM Please respond to Peter Sloboda <petersloboda@earthlink.net> To: informix-list@iiug.org cc: (bcc: Sujit Pal) Subject: Tabnames Hi, 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. Thanx, Peter

↪ replying to Sujit.Pal@bankofamerica.com

June Tong — Thu, 08 Jul 1999 05:03:14 GMT — source: Informix-list mailing list archive (1991-1998)

and tabtype = 'T' -- (I think) otherwise you will also get views. June june_t@hotmail.com Still alive -- just when you thought it was safe to come out with the chocolate... Please do not send Informix questions to this account. I would add 'Please do not send spam to this account' but I suppose I would be wasting my bits. Sujit.Pal@bankofamerica.com wrote: > Peter > > Try this: > > database yourdatabasename; > select tabname from systables where tabid > 99;> > HTH > Sujit > > Peter Sloboda <petersloboda@earthlink.net> on 07/06/99 01:06:47 PM > > Please respond to Peter Sloboda <petersloboda@earthlink.net> > > To: informix-list@iiug.org > cc: (bcc: Sujit Pal) > Subject: Tabnames > > Hi, > 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. > Thanx, > Peter

↪ replying to June Tong

Robert Taylor — Mon, 12 Jul 1999 13:44:50 +0100 — source: Informix-list mailing list archive (1991-1998)

........and synonymns...... June Tong <june_t@hotmail.com> wrote in message news:37843144.7ECD18C9@hotmail.com... > and tabtype = 'T' -- (I think) > > otherwise you will also get views. > > June > > june_t@hotmail.com > Still alive -- just when you thought it was safe to come out with the > chocolate... > > Please do not send Informix questions to this account. > I would add 'Please do not send spam to this account' > but I suppose I would be wasting my bits. > > Sujit.Pal@bankofamerica.com wrote: > > > Peter > > > > Try this: > > > > database yourdatabasename; > > select tabname from systables where tabid > 99;> > > > HTH > > Sujit > > > > Peter Sloboda <petersloboda@earthlink.net> on 07/06/99 01:06:47 PM > > > > Please respond to Peter Sloboda <petersloboda@earthlink.net> > > > > To: informix-list@iiug.org > > cc: (bcc: Sujit Pal) > > Subject: Tabnames > > > > Hi, > > 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. > > Thanx, > > Peter >