On 10/8/07, chetana bhargav <[EMAIL PROTECTED]> wrote: > We got two tables, tableA & tableB. > > tableB is turning out to be a many-one relation where in we have many rows of > tableA mapping to one row of tableB, would like to know what is the best way > to delete a row in tableB > > 1. Keep a reference count of the number of rows that are referring to this ( > to be honest I dont think this is good) > 2. More on similar lines instead of count have row-ids and attach a trigger
I'm not clear on the scenario here. Is this a like a foreign key relationship, so you want a delete of a row in table B to delete all referring rows from A? Is this a garbage collection situation, where you want a row in B to go away when all referring rows in A are deleted? Something else? ----------------------------------------------------------------------------- To unsubscribe, send email to [EMAIL PROTECTED] -----------------------------------------------------------------------------
