Re: How to list alle tables in database

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; -- Peter Lancashire Information Systems Specialist, Bayer plc Eastern Way, Bury St Edmunds, Suffolk, IP32 7AH, UK Tel: +44-1635-562258, Fax: +44-1635-562281 --- If all else fails, read the instructions. All opinions are my own and not those of Bayer plc. My Internet plumbing does not allow me to mail and post news together. Sorry. --- Join Infuse, the UK Informix User Group at http://www.infuse.org.uk/