Re: can't delete!!

Posted in 1998

Rainer Schaub — Tue, 01 Sep 1998 12:10:13 +0200 — source: Informix-list mailing list archive (1991-1998)

> There is a constraint to another table. In this other table the field which is referenced has not the name switch_id, becausewith your select at systables/indexes you can't find it. make a dbschema -d DATABASE and look for the constraint (informix.switches_key) and delete this one entry in the referenced table first. good luck > delete from switches where switch_id = "2JB" > and I get:> 692: Key value for constraint (informix.switches_key) is still being> referenced. > This switch_id is not in any other table in my database. Any ideas? >