Path: utzoo!mnetor!uunet!lll-winken!lll-lcc!well!mjr
From: mjr@well.UUCP (Matthew Rapaport)
Newsgroups: comp.databases
Subject: Re: Referential Integrity Constraints (Long)
Message-ID: <5379@well.UUCP>
Date: 6 Mar 88 06:36:28 GMT
References: <1342@polyslo.UUCP> <502@ashton.UUCP> <1401@polyslo.UUCP>
Reply-To: mjr@well.UUCP (Matthew Rapaport)
Organization: Whole Earth 'Lectronic Link, Sausalito, CA
Lines: 12
Keywords: Referential Integrity, Triggers, SYBASE, UNIFY

In article <1401@polyslo.UUCP> lchirica@polyslo.UUCP (Laurian Chirica) writes:
>...  I do not know of any relational
>DBMS that performs cascaded deletes...

Supra from Cincom systems of Cincinati (sp?) will perform cascaded deletes
from external views if instructed to do so.  Supra is also one of the
"relational" dbms that inforces relational integrity inside the directory
and independent of indexes.  It is not perfect in this regard however, the
current release, for example will not allow a foreign key to be NULL even
if that is a legal value from the business perspective.  I understand the
next release will allow such things...

Matthew Rapaport mjr@well (ptsfa!well!mjr)