Re: How to list alle tables in database

Posted in 1998

Rainer Schaub — Tue, 01 Sep 1998 14:00:05 +0200 — source: Informix-list mailing list archive (1991-1998)

SELECT tabname FROM informix.systables WHERE tabid >= 100 and tabtype = "T"; otherwise you get synonyms (tabtype = "S") and views ("V")