How do I find join index that references specific objects
I'm trying to create a DROP/CREATE script for JI's to execute before/after daily batch jobs. The DROP statement needs to contain the databasename.jiname of any JI's that reference one, or more tables in the production database. This is a problem if the JI is in another database than the object(s) it references and has the same name as another JI. I can get the objects that are referenced from dbc.indexes and the databasename.jiname from dbc.TVM but I don't know how to join those two tables.