Tabnames

Posted in 1999

Peter Sloboda — Tue, 06 Jul 1999 16:06:47 -0400 — source: Informix-list mailing list archive (1991-1998)

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 Peter Sloboda

Michael Krzepkowski — Tue, 06 Jul 1999 21:00:24 GMT — source: Informix-list mailing list archive (1991-1998)

database db_name select tabname from systables HTH Michael Peter Sloboda wrote: > 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 Peter Sloboda

Peter Sloboda — Wed, 07 Jul 1999 10:57:13 -0400 — source: Informix-list mailing list archive (1991-1998)

Thanx guys.