Generic way to DELETE Child Rows

[ShankarJ]

Hi!

Before I venture into trying to do this on my own, I would like to know if any of you could guide me to create a Stored Procedure which takes as it's parameters the Table Name and the Row ID, finds all the dependant Child Tables and their ParentID link column to the given Table and generate SQL statements to delete these Child Rows. I need this to delete a Parent Row. All the Parent-Child foreign key relationship DO NOT have the CASCADE option on UPDATE.

Appreciate any help I can get.

Regards

 

[ShankarJ]

Hi!

Found the solution I wanted from the links below :

http://www.sqlteam.com/item.asp?ItemID=8595

http://www.sqlteam.com/forums/topic.asp?TOPIC_ID=14594

I just need to change it to NOT use cursors though.

Of course, any other suggestions from the SQL Gurus are welcome.

Regards