RE: Delete rule "SET NULL"
"Zabach, Elke" <[email protected]>
| Newsgroups | gmane.comp.db.sapdb.general |
|---|---|
| Message-ID | <[email protected]> |
Michael Slinn wrote:
> Revisiting the topic (http://groups.yahoo.
> com/group/sapdb-general/message/3857), I also have a need for ON
> DELETE SET NULL.
Well, where is the problem?
MaxDB knows the delete rule ON DELETE SET NULL.
There are only two restrictions:
1. SET NULL cannot be defined for columns specified as NOT NULL resp. PRIMARY KEY (which has to be NOT NULL)
2. If you have more than one constraint, then those referential constraints have to be defined that the final result
does not depend on the sequence, the constraints are checked (no restrict/cascade-mixture and so on)
So, I do not know, why you don't just use the ON DELETE SET NULL
Elke
SAP Labs Berlin