Yesterday I tried Visio Pro, it's got a module where you specify an
ODBC datasource and get a nice pretty picture of your database
structure.
Alternatively, using Access, create links to all the tables in the
mysql database and add in the relationships in the Relationships window.
Senior Person can then do whatever he wants using Access.
-dan
> -----Original Message-----
> From: rgrunloh@stripped
> [mailto:rgrunloh@stripped]
> Sent: 13 July 1999 19:27
> To: mysql@stripped
> Cc: rgrunloh@stripped
> Subject: FW: Graphical diagram of database structure?
>
>
> Hi,
>
> I am doing a test implementation of an open-source web-based
> Electronic
> Library Reserves project (http://timesync.gmu.edu/OSCR/)
> which uses Mysql.
> Following the script provided I've created 3 tables (no data
> yet). Now our
> senior person, who is versed in MS Access 97 & MS SQL, wants
> to look at
> the structure. Is there a way to either
>
> a) get a pretty chart of the tables with arrows showing key
> relationships, like MS Access's "Tools | Relationships ..." menu? or,
>
> b) take a file of sql statements (a script to create the
> tables in Mysql)
> and input that into MS Access to create an identically-structured
> database?
>
> If not, what's the next-best way to generate a listing of
> tables/fields
> that I can print out for him?
>
> Thanks; I hope this isn't a FAQ, but I couldn't find anything in the
> manual.html about this.
>
> Robert Grunloh
> Support Systems Analyst,
> University of Arizona Library
> Tucson, AZ 85721
> rgrunloh@ {elwood | bird} .library.arizona.edu
> ----------------------------------------------
>
>
>
> ---------------------------------------------------------------------
> Please check
> "http://www.mysql.com/Manual_chapter/manual_toc> .html" before
>
> posting. To request this thread, e-mail
> mysql-thread7182@stripped
>
> To unsubscribe, send a message to the address shown in the
> List-Unsubscribe header of this message. If you cannot see it,
> e-mail mysql-unsubscribe@stripped instead.
>
