RE: How to generate view schemas?

SELECT btype, b.tabname, dtype, d.tabname FROM sysdepend, systables b, systables d WHERE btabid=b.tabid AND dtabid=d.tabid AND b.tabname="tabname"Should be a start. It only goes one level deep though. You have to executed it again with the dependencies you get to see if they have views which depend on them. Hope this helps, Will >===== Original Message From AX <samuelNOsaSPAM@ematic.com.invalid> ===== >Hi everyone! > >Does anyone know of an Informix 7x utility/program that >generates the schema(s) for all the view(s) which are derived >from a given table/view? > >I'm thinking of something like the dbschema utility, maybe we >can call it dbview, which would take the table or view name as >an argument and generate the schema(s) of the dependent view(s) >as output. > >I looked in www.iiug.org but didn't find anything useful. Seems >strange that no one needed to do this yet, since the views are >lost whenever any the source table(s) are dropped. And if you >didn't have a recent dbschema of the view itself saved, you'll >have to rebuild the view from scratch. > >I was trying to write my own dbview using the sysviews, >systables and sysdepend tables in the catalogs but I haven't >gotten very far yet. > >Thanks for your input. > >AX. > >* Sent from RemarQ http://www.remarq.com The Internet's Discussion Network * >The fastest and easiest way to search and participate in Usenet - Free! ------------------------------------------------------------ This e-mail has been sent to you courtesy of OperaMail, as a free service from Opera Software, makers of the award-winning Web Browser, Opera. Visit us at http://www.opera.com/ or our portal at: http://www.myopera.com/ Your free e-mail account is waiting at: http://www.operamail.com/ ------------------------------------------------------------