[thelist] oracle related database error
Ron.Luther at hp.com
Mon Aug 30 08:20:27 CDT 2010
Daniel Kessler asked:
>>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.
Not something I play with much, but Oracle has a plethora of 'administrative' tables. Take a look at the USER_CONSTRAINTS table.
My guess is you want something like "Select * from USER_CONSTRAINTS where TABLE_NAME = 'People';"
That should get you the names of all the constraints referencing your table. From there your schema naming convention should let you figure out which table name goes with which constraint name.
More information about the thelist