raghuveer126 (10/18/2012)

---

i have datawarehouse database where there is only primary key and no foreign keys.

I have a condition from one table and based on that condition i have to delete the records from other tables.

I am trying to use joins and delete the records based on that condition. Is this right way or else anyother way to delete.

EamonSQL (10/19/2012)

---

Create a trigger that seeks out any child records and deletes them if found.

Eamon

raghuveer126 (10/22/2012)

---

I did inner join put a where clause and deleted one table there were x rows affected but when i try to put one more table from the inner joins i used in the delete statement it is not deleting the related records in that table, it says 0 rows affected.
If it has no foreign keys than how do i know which table to delete first...