Prev: Stored procedure, delete from multiple tables
Next: Any way to select all fields except 1?
From: MaMo on 9 Feb 2010 08:49
Hello,

In a stored procedure i want to delete data from multiple tables.

Now i am doing this in my stored procedure:

DELETE FROM table1

DELETE FROM table2

DELETE FROM table3

DELETE FROM table4

.... and so on

Is it possible to do this in a more elegenat manner like holding the table
names in some kind of array or variable and use a cursor or something to do
de deletion?

Any help would be very appreciated!!!

Marcel


 | 
Pages: 1
Prev: Stored procedure, delete from multiple tables
Next: Any way to select all fields except 1?