Subject Re: [IB-Architect] Circular Foreign Key Dependencies
Author Jim Starkey
At 02:27 PM 3/24/01 +1100, Geoff Worboys wrote:
>> and there is no easy to delete an unnamed foreign
>> key constraint.
>Why unnamed? Can you explain a bit more about what you mean here and
>why it is a problem or solution to this situation.

"create table detail (a int not null references master)" has
no name for the implicit foreign key, and lacking a name. The
only decoder-ring-set sanctified way to drop a foreign key
is "alter table drop constraint <constraint-name>". But then
I'm too cheap to buy a copy of the standard. Exactly why
a standard is protected like a classified document is a
different question.

Jim Starkey