RE: Delete rule "SET NULL"

Thank you, that was most helpful.

Mike


> 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
>
>