Re: Oracle man with Informix questions

Posted in 2008

Floyd Wellershaus — Fri, 16 May 2008 10:17:23 -0500 (CDT) — source: Usenet: comp.databases.informix

systables, syscolumns and many others. do a select tabname from systables where tabid < 99, and you can see the whole bunch of them. Plus tons more in the sysmaster database. ----- Original Message ----- Subject: Oracle man with Informix questions Date: Fri, May 16, 2008 11:06 From: "freecycle" <f.cycle@yahoo.com> Hi, just having to undergo the delights of Informix ATM. > Is there any equivalent to Oracle views such as > all_tables or all_tab_columns in Informix? > TIA, > |FC > _______________________________________________ > Informix-list mailing list > Informix-list@iiug.org > http://www.iiug.org/mailman/listinfo/informix-list > >

↪ replying to Floyd Wellershaus

Fernando Nunes — Sat, 17 May 2008 10:58:35 +0100 — source: Usenet: comp.databases.informix

Floyd Wellershaus wrote: > systables, syscolumns and many others. > do a select tabname from systables where tabid < 99, and you can see the > whole bunch of them. > Plus tons more in the sysmaster database. > > > > > > ----- Original Message ----- > Subject: Oracle man with Informix questions > Date: Fri, May 16, 2008 11:06 > From: "freecycle" <f.cycle@yahoo.com> > Hi, just having to undergo the delights of Informix ATM. >> Is there any equivalent to Oracle views such as >> all_tables or all_tab_columns in Informix? >> TIA, >> |FC >> _______________________________________________ >> Informix-list mailing list >> Informix-list@iiug.org >> http://www.iiug.org/mailman/listinfo/informix-list >> >> Informix SQL Reference also has some of them (if not all) documented. Depending on your version: http://publib.boulder.ibm.com/infocenter/idshelp/v111/index.jsp (change v11 with v10 for version 10). Regards