>Violation of FOREIGN KEY constraint "INTEG_95" on table "SCHICHT"
>Statement: Alter table DATEN add foreign key (SCHICHT) references
>SCHICHT (SCHICHTID) on update no action on delete cascade

>How to find out what fields are indexed or referenced by INTEG_95 ?

Don't know the answer to your question, but try
SELECT DISTINCT SCHICHT FROM DATEN
WHERE NOT EXISTS(SELECT 1 FROM SCHICHT WHERE SCHICHT.SCHICHTID =
DATEN.SCHICHT)
to find which values of SCHICHT exist in DATEN that is not in your SCHICHT
table.

Set