Arthur, et al --
...and then Arthur Fuller said...
% I don't know about anyone else, but for this sort of thing I love the
% program called DeZign, which is a data-modeling tool. You can "draw" your
% tables and their columns and set up relations and so on. DeZign will then
% write your code for you.
I actually broke out a Windows box to try it out so that I could see how
it would relate keys :-) Now I have some sample syntax for foreign keys,
if nothing else.
Anyone know of a design tool which runs on Linux and FreeBSD?
% Personally, I like to keep all my "drop" statements in one script, all my
% "create" scripts in another, and all my "populate" scripts in yet another.
Yeah, I think I'll do something like that.
Thanks & HAND & Happy Holidays
David T-G * There is too much animal courage in
(play) davidtg@stripped * society and not sufficient moral courage.
(work) davidtgwork@stripped -- Mary Baker Eddy, "Science and Health"
http://www.justpickone.org/davidtg/ Shpx gur Pbzzhavpngvbaf Qrprapl Npg!