<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.0 Transitional//EN">
<HTML><HEAD>
<META http-equiv=Content-Type content="text/html; charset=us-ascii">
<META content="MSHTML 6.00.2900.2802" name=GENERATOR></HEAD>
<BODY
style="WORD-WRAP: break-word; khtml-nbsp-mode: space; khtml-line-break: after-white-space">
<DIV dir=ltr align=left><SPAN class=122501314-07032006><FONT face=Arial
color=#0000ff size=2>You could use an ODBC driver to connect to the database
using MS Access and produce some sort of diagram within
access.</FONT></SPAN></DIV>
<DIV dir=ltr align=left><SPAN class=122501314-07032006><FONT face=Arial
color=#0000ff size=2></FONT></SPAN> </DIV>
<DIV dir=ltr align=left><SPAN class=122501314-07032006><FONT face=Arial
color=#0000ff size=2>I have not used access to create DB diagrams before but am
presuming it has some form of inbuilt GUI facility.</FONT></SPAN></DIV>
<DIV dir=ltr align=left><SPAN class=122501314-07032006><FONT face=Arial
color=#0000ff size=2></FONT></SPAN> </DIV>
<DIV dir=ltr align=left><SPAN class=122501314-07032006><FONT face=Arial
color=#0000ff size=2>Pete</FONT></SPAN></DIV><BR>
<DIV class=OutlookMessageHeader lang=en-us dir=ltr align=left>
<HR tabIndex=-1>
<FONT face=Tahoma size=2><B>From:</B> phpwm-bounces@mailman.lug.org.uk
[mailto:phpwm-bounces@mailman.lug.org.uk] <B>On Behalf Of </B>Ian
Munday<BR><B>Sent:</B> 07 March 2006 12:35<BR><B>To:</B>
phpwm@mailman.lug.org.uk<BR><B>Subject:</B> [Phpwm] Database Diagram from SQL
definition<BR></FONT><BR></DIV>
<DIV></DIV>I apologise for being slightly off topic, but I need to produce a
database diagram (of a type suitable to present to a client) from a manually
written SQL definition file of the following format:
<DIV><BR class=khtml-block-placeholder></DIV>
<DIV>----------</DIV>
<DIV><BR class=khtml-block-placeholder></DIV>
<DIV style="MARGIN: 0px"><FONT class=Apple-style-span face=Monaco size=3><SPAN
class=Apple-style-span style="FONT-SIZE: 11px">CREATE TABLE tbl_Divisions
(</SPAN></FONT></DIV>
<DIV style="MARGIN: 0px"><FONT class=Apple-style-span face=Monaco size=3><SPAN
class=Apple-style-span style="FONT-SIZE: 11px"> </SPAN></FONT><FONT
class=Apple-style-span face=Monaco size=3><SPAN class=Apple-style-span
style="FONT-SIZE: 11px">ID int(11) NOT NULL auto_increment,</SPAN></FONT></DIV>
<DIV style="MARGIN: 0px"><FONT class=Apple-style-span face=Monaco size=3><SPAN
class=Apple-style-span style="FONT-SIZE: 11px"> </SPAN></FONT><FONT
class=Apple-style-span face=Monaco size=3><SPAN class=Apple-style-span
style="FONT-SIZE: 11px">Name varchar(100) NOT NULL default
'',</SPAN></FONT></DIV>
<DIV style="MARGIN: 0px"><FONT class=Apple-style-span face=Monaco size=3><SPAN
class=Apple-style-span style="FONT-SIZE: 11px"> ...</SPAN></FONT></DIV>
<DIV style="MARGIN: 0px"><FONT class=Apple-style-span face=Monaco size=3><SPAN
class=Apple-style-span style="FONT-SIZE: 11px"> </SPAN></FONT><FONT
class=Apple-style-span face=Monaco size=3><SPAN class=Apple-style-span
style="FONT-SIZE: 11px">PRIMARY KEY</SPAN></FONT><FONT class=Apple-style-span
face=Monaco size=3><SPAN class=Apple-style-span style="FONT-SIZE: 11px">
</SPAN></FONT><FONT class=Apple-style-span face=Monaco size=3><SPAN
class=Apple-style-span style="FONT-SIZE: 11px">(ID),</SPAN></FONT></DIV>
<DIV style="MARGIN: 0px"><FONT class=Apple-style-span face=Monaco size=3><SPAN
class=Apple-style-span style="FONT-SIZE: 11px"> </SPAN></FONT><FONT
class=Apple-style-span face=Monaco size=3><SPAN class=Apple-style-span
style="FONT-SIZE: 11px">UNIQUE KEY Name (Name)</SPAN></FONT></DIV>
<DIV style="MARGIN: 0px"><FONT class=Apple-style-span face=Monaco size=3><SPAN
class=Apple-style-span style="FONT-SIZE: 11px">)
TYPE=InnoDB;</SPAN></FONT></DIV>
<DIV><BR class=khtml-block-placeholder></DIV>
<DIV style="MARGIN: 0px"><FONT class=Apple-style-span face=Monaco size=3><SPAN
class=Apple-style-span style="FONT-SIZE: 11px">CREATE TABLE tbl_Departments
(</SPAN></FONT></DIV>
<DIV style="MARGIN: 0px"><FONT class=Apple-style-span face=Monaco size=3><SPAN
class=Apple-style-span style="FONT-SIZE: 11px"> </SPAN></FONT><FONT
class=Apple-style-span face=Monaco size=3><SPAN class=Apple-style-span
style="FONT-SIZE: 11px">ID int(11) NOT NULL auto_increment,</SPAN></FONT></DIV>
<DIV style="MARGIN: 0px"><FONT class=Apple-style-span face=Monaco size=3><SPAN
class=Apple-style-span style="FONT-SIZE: 11px"> </SPAN></FONT><FONT
class=Apple-style-span face=Monaco size=3><SPAN class=Apple-style-span
style="FONT-SIZE: 11px">DivisionID int(11) NOT NULL default
'0',</SPAN></FONT></DIV>
<DIV style="MARGIN: 0px"><FONT class=Apple-style-span face=Monaco size=3><SPAN
class=Apple-style-span style="FONT-SIZE: 11px"> </SPAN></FONT><FONT
class=Apple-style-span face=Monaco size=3><SPAN class=Apple-style-span
style="FONT-SIZE: 11px">Name varchar(100) NOT NULL default
'',</SPAN></FONT></DIV>
<DIV style="MARGIN: 0px"><FONT class=Apple-style-span face=Monaco size=3><SPAN
class=Apple-style-span style="FONT-SIZE: 11px"> ...</SPAN></FONT></DIV>
<DIV style="MARGIN: 0px"><FONT class=Apple-style-span face=Monaco size=3><SPAN
class=Apple-style-span style="FONT-SIZE: 11px"> </SPAN></FONT><FONT
class=Apple-style-span face=Monaco size=3><SPAN class=Apple-style-span
style="FONT-SIZE: 11px">PRIMARY KEY</SPAN></FONT><FONT class=Apple-style-span
face=Monaco size=3><SPAN class=Apple-style-span style="FONT-SIZE: 11px">
</SPAN></FONT><FONT class=Apple-style-span face=Monaco size=3><SPAN
class=Apple-style-span style="FONT-SIZE: 11px">(ID),</SPAN></FONT></DIV>
<DIV style="MARGIN: 0px"><FONT class=Apple-style-span face=Monaco size=3><SPAN
class=Apple-style-span style="FONT-SIZE: 11px"> </SPAN></FONT><FONT
class=Apple-style-span face=Monaco size=3><SPAN class=Apple-style-span
style="FONT-SIZE: 11px">UNIQUE KEY DivisionID
(DivisionID,Name),</SPAN></FONT></DIV>
<DIV style="MARGIN: 0px"><FONT class=Apple-style-span face=Monaco size=3><SPAN
class=Apple-style-span style="FONT-SIZE: 11px"> </SPAN></FONT><FONT
class=Apple-style-span face=Monaco size=3><SPAN class=Apple-style-span
style="FONT-SIZE: 11px">KEY IX_tbl_Departments_DivisionID
(DivisionID),</SPAN></FONT></DIV>
<DIV style="MARGIN: 0px"><FONT class=Apple-style-span face=Monaco size=3><SPAN
class=Apple-style-span style="FONT-SIZE: 11px"> </SPAN></FONT><FONT
class=Apple-style-span face=Monaco size=3><SPAN class=Apple-style-span
style="FONT-SIZE: 11px">CONSTRAINT `tbl_Departments__ibfk1` FOREIGN KEY
(`DivisionID`) REFERENCES `tbl_Divisions` (`ID`) ON DELETE CASCADE ON UPDATE
CASCADE</SPAN></FONT></DIV>
<DIV style="MARGIN: 0px"><FONT class=Apple-style-span face=Monaco size=3><SPAN
class=Apple-style-span style="FONT-SIZE: 11px">)
TYPE=InnoDB;</SPAN></FONT></DIV>
<DIV><BR class=khtml-block-placeholder></DIV>
<DIV><FONT class=Apple-style-span face=Monaco size=3><FONT
class=Apple-style-span size=3><SPAN class=Apple-style-span
style="FONT-SIZE: 11px">.</SPAN></FONT><SPAN class=Apple-style-span
style="FONT-SIZE: 11px">..</SPAN></FONT></DIV>
<DIV><FONT class=Apple-style-span face=Monaco size=3><SPAN
class=Apple-style-span style="FONT-SIZE: 11px"><BR
class=khtml-block-placeholder></SPAN></FONT></DIV>
<DIV>----------
<DIV>
<DIV><BR class=khtml-block-placeholder></DIV>
<DIV>Ideally it would be of the form that you would see in SQL Server.</DIV>
<DIV><BR class=khtml-block-placeholder></DIV>
<DIV>I thought of writing a quick script in PHP to parse table definitions and
display them in formatted tables on a web page, but I can't believe I wouldn't
be reinventing the wheel.</DIV>
<DIV>
<DIV><BR class=khtml-block-placeholder></DIV>
<DIV>Anybody needed to do this in the past?</DIV>
<DIV><BR class=khtml-block-placeholder></DIV>
<DIV>Many thanks,</DIV>
<DIV><BR class=khtml-block-placeholder></DIV>
<DIV>Ian</DIV></DIV></DIV></DIV>
</BODY></HTML>