Subject | Re: FK confusion |
---|---|
Author | Ali Gökçen |
Post date | 2006-07-09T18:04:03Z |
Pardon,
it was my sunday laziness... references on "Cust"(ID).
...
it was my sunday laziness... references on "Cust"(ID).
...
>Did you commited this create index command and was it ok?
> CREATE UNIQUE INDEX "IDX_Cust_13" ON "Cust" (ID);
>
>ON
> ===================== Alter Table doesn't work
> ==================================
> ALTER TABLE "ACCCHEM" ADD CONSTRAINT "Cust_ACCCHEM"
> FOREIGN KEY ("Acc ID") REFERENCES "Cust" (ID) ON DELETE CASCADE
> UPDATE CASCADE;metadata
>
> I get this error message:
>
> This operation is not defined for system tables.Unsuccessful
> update.
> Could not find UNIQUE INDEX with specified columns.
>
> IDX_Cust_13 is there, though. What am I overlooking?
>
>
> Michael D. Spence
> Mockingbird Data Systems, Inc.
>