Re: How to list structure of all tables of my database ?
Posted in 2000
"CG." wrote:
>
> Hi,
>
> 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..
What about dbschema?
Cheers,
--
Mark.
+----------------------------------------------------------+-----------+
| Mark D. Stock mailto:mdstock@mydas.freeserve.co.uk |//////// /|
| http://www.informix.com http://www.informixhandbook.com |///// / //|
| http://www.iiug.org +-----------------------------------+//// / ///|
| |This email will self-destruct in |/// / ////|
| |10 sec. If you received this email |// / /////|
| |in error, sorry about the mess. |/ ////////|
+----------------------+-----------------------------------+-----------+