Re: table listing

Posted in 2006

Topics: Server Administration, Platform-Specific Issues

Obnoxio The Clown — Thu, 14 Sep 2006 02:49:24 +0100 (BST) — source: Usenet: comp.databases.informix

vallinayag@yahoo.co.in said: > Hi > > I am using dbaccess from linux to access Informix db. > > Is there any sql that will list all the tables in the database i chose. select tabname from systables ??? -- Bye now, Obnoxio "... no bill is required as no value was provided." -- Christine Normile -- This message has been scanned for viruses and dangerous content by OpenProtect(http://www.openprotect.com), and is believed to be clean.

↪ replying to Obnoxio The Clown

Doug Lawry — Thu, 14 Sep 2006 10:43:35 +0100 — source: Usenet: comp.databases.informix

More exactly, this should be: SELECT tabname FROM systables WHERE tabid > 99 AND tabtype = 'T' ORDER BY tabname -- Regards, Doug Lawry www.douglawry.webhop.org "Obnoxio The Clown" <obnoxio@serendipita.com> wrote in message news:mailman.453.1158197634.20706.informix-list@iiug.org... > > vallinayag@yahoo.co.in said: >> Hi >> >> I am using dbaccess from linux to access Informix db. >> >> Is there any sql that will list all the tables in the database i chose. > > select tabname > from systables> > ??? > > -- > Bye now, > Obnoxio

Glossary

dbaccess