Hi All,
We are designing a data base landed in some problems would like to know what
approach is the best.
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
-x-
Chetana
____________________________________________________________________________________
Catch up on fall's hot new shows on Yahoo! TV. Watch previews, get listings,
and more!
http://tv.yahoo.com/collections/3658
