| Subject | Re: [IB-Architect] Circular Foreign Key Dependencies |
|---|---|
| Author | Jim Starkey |
| Post date | 2001-03-24T15:32:22Z |
At 02:27 PM 3/24/01 +1100, Geoff Worboys wrote:
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
>"create table detail (a int not null references master)" has
>
>> 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.
>
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