DA2 - multiple deletes and referential integrity

[msummers194171]

My client wants to delete orders from an eCart order table in a batch mode, i.e., select multiple orders and click delete once. I can see that DA2 has a multiple delete option. Will this option maintain referential integrity in the various eCart tables (i.e., when an order is deleted from the orders table is the order details table then adjusted so that the order's details are also removed)?

Thanks!

[Ray Borduin]

It will not by default. You would have to create a view to define the referenced tables you want deleted and their relationship, then deleting from that view should delete the referenced tables as you have defined it.

[msummers194171]

It will not by default. You would have to create a view to define the referenced tables you want deleted and their relationship, then deleting from that view should delete the referenced tables as you have defined it.

I would have to do this then outside of DA2, right? There is no such capability to create views or to delete tables from a view within DA, is there?

[Ray Borduin]

No you would have to do it in the database administrative tool. It cannot be done directly from DW.