We have a change in our database that means we need to check our universes to see if the column in question is used in any joins, object, etc Under version 6 we used to just query the repository tables to see if the column name appeared there. Is there a way we can query in XIr3.1 to do the same t…

Query CMS database for SQL used in objects?

system February 23, 2010, 12:49pm 2

Hi,

Use either this utility:

or this one:

to document your universes. Then you should be able to get what you need from data from the excel files.

Marek Chladny (BOB member since 2003-11-27)