Re: How to list structure of all tables of my database ?

From: "CG." <cgauder@mail.caramail.com> > >I'm trying to list all the structures of my Informix 7 database. >If using dbaccess, i can visualize the sutrcuture of each of the table, >but only one by one, using the syntax : > >info columns for xxx > >where xxx if the name of the table. > >Does someone can provide me with informations for the listing of columns >for all the tables, using for example something l:ike : > >info columns for * > >but this doesn't work.. I haven't tried this, but how about output to pipe "dbaccess yourdb" without headers select "info columns for " || trim(tabname) || ";" from systables where tabid > 99 )just to be different( _____________________________________________________________________________________ Get more from the Web. FREE MSN Explorer download : http://explorer.msn.com