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 > > _______________________________________________ sapdb.general mailing list [EMAIL PROTECTED] http://listserv.sap.com/mailman/listinfo/sapdb.general
