Table information

Posted in 1999

Shevkar, Mukund — Thu, 10 Jun 1999 11:15:33 -0700 — source: Informix-list mailing list archive (1991-1998)

I just was wondering if there is any utility in repository that will list dbschema , indexes , constraints and permissions for every table on a separate page ? Can anybody help ? TIA Mukund

↪ replying to Shevkar, Mukund

Art S. Kagel — Fri, 11 Jun 1999 13:00:23 -0400 — source: Informix-list mailing list archive (1991-1998)

"Shevkar, Mukund" wrote: > > I just was wondering if there is any utility in repository that will list > dbschema , > indexes , > constraints and > permissions > > for every table on a separate page ? > Can anybody help ? Download the source to myschema.ec from the Repository in the package utils2_ak, make a few online changes, and voila you have your own version of myschema.ec that writes a formfeed to the schema file. I'd put that into an ANSI comment string (like: "{\\n\\f}") so that the SQL is still valid or at least make it another commandline option. Art S. Kagel