DELETE From Multiple tables

[nirs]

is there a way to DELETE from Multiple table that are linked

e.g.
DELETE
FROM dbo.T_Measurment RIGHT OUTER JOIN
dbo.T_Item ON dbo.T_Measurment.itemNo = dbo.T_Item.itemNo RIGHT OUTER JOIN
dbo.T_Batch ON dbo.T_Item.batchNo = dbo.T_Batch.batchNo LEFT OUTER JOIN
dbo.T_BatchRemark ON dbo.T_Batch.batchNo = dbo.T_BatchRemark.batchNo

i want to do that insted of checking each table befor deleting. this has to be done because of constraints.

thank you

 

[r937]

because of constraints? what kind of constraints?

if they are foreign key constraints....

also, which tables to you want to delete from? your example query links several tables, do you want to delete everything from all of them? or just linked rows from all of them? or only unmatched rows? (i'm guessing, because you used RIGHT OUTER)

a little more detail, if you please

rudy

http://r937.com/

SQL Consulting

 

[nirs]

i want to delete records under a where condition
i all those tables are conected and insted of deleting from each table separatly i want to do it in one time

 

[r937]

perhaps you could do it with a cascading delete

define primary and foreign keys on your tables, and on the foreign keys, declare ON DELETE CASCADE

then the database will delete all related rows for you automatically



rudy

http://r937.com/

SQL Consulting