Daniel, I use a program called Navicat in order to manage my databases. Using it, I can see which tables are related to the table I'm viewing, and by what fields. I'm sure other programs have a similar feature, though. -jeremy On Mon, Aug 30, 2010 at 7:12 AM, Daniel Kessler <danielk at umd.edu> wrote: > I'm working in Oracle. I have a table of People with unique IDs. I want to > delete one of the people, but one of my other related tables has a > relationship with that person, so I can't delete them, receiving the error > "integrity constraint (DPCH.SYS_C0096833) violated - child record found". > > I understand the problem. However, how do I determine which related table > includes the person, so that I can go and delete the information for that > related table? I have about 100 tables. > > -- > > Daniel Kessler > > University of Maryland College Park > School of Public Health > 2242A SPH Building > College Park, MD 20742-2611 > Phone: 301-405-2545 > http://sph.umd.edu > > > > > -- > > * * Please support the community that supports you. * * > http://evolt.org/help_support_evolt/ > > For unsubscribe and other options, including the Tip Harvester > and archives of thelist go to: http://lists.evolt.org > Workers of the Web, evolt !