RE: master db diagram

Posted in 2000

Howard, Paul — Wed, 5 Jan 2000 09:28:35 -0500 — source: Informix-list mailing list archive (1991-1998)

Art, Are you saying in a round about way that learning about the sysmaster database is still a trial and error process? > ---------- > From: Art S. Kagel[SMTP:kagel@bloomberg.net] > Reply To: kagel@bloomberg.net > Sent: Tuesday, January 04, 2000 5:09 PM > To: informix-list@iiug.org > Subject: Re: master db diagram > > There is no such chart. The Administrator's Guide document some of the > tables and views but only a small number. > > The file: $INFORMIXDIR/etc/sysmaster.sql contains the schema used to > create > the tables and some inline documentation. > > There was an article, by Knutsen, in a recent Informix TechNotes > (available > online from the Informix WEB Site) on using sysmaster which I believe will > be > included in Ron M. Flannery's new book "Informix Handbook" when the > publisher > finally gets it on the shelves. > > Art S. Kagel > > Sunil Bhaskarla wrote: > > > > Hi, > > Where can I find a diagram (showing relationships) of all system > tables in the master db? > > > > Thanks, > > Sunil > >