Posted by Stefan Rybacki on 02/17/06 14:27

-----BEGIN PGP SIGNED MESSAGE-----
Hash: SHA1

NC schrieb:
> Tony Peardon wrote:
>> I've got a bunch of tables now, and I'm starting to lose track
>> of table relations. Is there a command, or even a program,
>> that I can use to visually see my relationships?
>
> Relationshpis are not stored within the database; rather, they are
> defined on per-query basis using JOIN clauses. Programs that allow you
> to visualize relationships simply store your "notes to self" and help
> you build queries based on those notes. So, in my opinion, the best
> (and vendor-independent) solution is to simply document your database
> design, and not just the relationships, but purpose of tables and
> fields as well.
>


Thats not complete true. If you're using a RDBMS which supports foreign
key constraints you're able to visualize at least them and they should
represent the relations.
In fact I fully agree to your statement, that documentation is one of
the most important things.

Regards
Stefan

> Cheers,
> NC
>

-----BEGIN PGP SIGNATURE-----
Version: GnuPG v1.4.2.1 (MingW32)

iD8DBQFD9cEUyeCLzp/JKjARAueYAKCBKX6imW6DaxQD6t8KzhLFLJDKVwCgwwZu
XVIfGHv3TNC5+xYxIhJn1oQ=
=fI8s
-----END PGP SIGNATURE-----

[Back to original message]