Re: How to list alle tables in database

In article <35D97C46.1531@bayer.co.uk>, Peter.Lancashire.PL1@bayer.co.uk (Peter Lancashire) wrote: > Webmaster wrote: > > > > Hi, > > > > We have a stripped Informix database that was delivered with Netscape > > Suitespot server suite. I'm using a LiveWire interface on the database > > for some simple SQL's. I was wondering if there are any commands to > > display all tables in the database? Normally I would use something > > like: > > > > syscatalog.syscolumns > > > > Regards, > > > > George > > > > PS: Please also reply by e-mail, I'm not a regular reader of this > > forum > Try this: > > SELECT tabname FROM informix.systables > WHERE tabid >= 100; If they is NewError floating around in the system you might like to filter on not matching sys* Paul Watson # I don't suffer from WF Software Ltd. # stress, I'm just Tel. (+44) 1436 674729 # a carrier Fax. (+44) 1436 678693 #