Stephan Szabo wrote:
>You're going to potentially have the constraints scattered in any case due
>to circular dependency chains. I'd think that having all the constraints
>in one place would be easier than trying to go through the list of tables
>that might be in a circular chain in order to find the constraints.
>
>
I still disagree. cyclic dependencies should be avoided anyhow. You'll
get an awful lot of trouble loading data in such a case. Some database
systems refuse to create such stuff right away (mssql).
Regards,
Andreas