delete from multiple tables with 1 query?

[Former Member]

Hi guys,

I wanted to know if this is possible?

I want to delete lines from multiple tables that have the same ID with only 1 query.

I don't want to use cascade deletion, because SAP DB doesn't support this.

Any help will be greatly appreciated.

Cheers,

George.

[former_member193399 · Accepted solution]

are you looking for a way thru ABAP or using SSMS (management studio)?

All i can think of it is in SSMS you create a batch transaction and put all the queries. But no single query does deletion of multiple tables.

-RT

[Former Member · Accepted solution]

Hi,

I am using the Java NW IDE.

I have the batch transaction and all the queries, but I wanted to build a single one.

I have seen code parts thoughout the web but I can't seem to make it work...

thanks.

Cheers,

George.

[former_member193399 · Accepted solution]

to the benefit for everyone, its better to mention what you have tried so far including the code snippets.