Any idea what the current status of this is? I thought it was already
there and am most disappointed that I can't create automatic entity
relationship diagrams from Visio :o(
I'll actually have to do some work now... :o)
Extract from mamual follows.
---------begin manual extract-------------
5.2.5 Foreign Keys
In the near future we will extend the FOREIGN KEY implementation so that
at least the information will be saved in the table specification file
and may be retrieved by mysqldump and
220.127.116.11 Reason NOT to use foreign keys
The only nice aspect of FOREIGN KEY is that it gives ODBC and some other
client programs the ability to see how a table is connected and to use
this to show connection diagrams and
to help in building applicatons.
MySQL will soon store FOREIGN KEY definitions so that a client can ask
for and receive an answer how the original connection was made. The
current `.frm' file format does not have
any place for it.
---------end manual extract-------------
Robin Bowes - System Development Manager - Room 405A
E.O.C., Overseas House, Quay St., Manchester, M3 3HN, UK.
Tel: +44 161 838 8321 Fax: +44 161 835 1657