Re: how to list all views that was created.

Posted in 2003

Jack Parker — Tue, 6 May 2003 15:34:14 -0400 — source: Usenet: comp.databases.informix

select tabname from systables where tabtype = 'V' for one If you need the text of the view, then you can either use dbschema, or take the tabid from systables and get viewtext from sysviews: select tabid, seqno, viewtext from sysviews where tabid in (select tabid from systables where tabtype = 'V') order by 1,2; cheers j. ----- Original Message ----- From: "Dorn Bhechsonggram" <dorn@bakcommunications.com> To: <informix-list@iiug.org> Sent: Tuesday, May 06, 2003 1:10 PM Subject: how to list all views that was created. I wonder if there is anything like "info tables" but for showing views that was created in the database. Thank you.