How to identify ODS Key Fields "in bulk"
I have been tasked with a job that requires looking at the "key fields" of all 150+ ODS objects in our system.
Eventually, I will use SQL to query the database directly regarding whether or not the key fields for each ODS are unique.
Given the ODS technical names, is there an easy way to determine the key fields in bulk ? I am trying to avoid the manual effort of going into change mode for each of the 150+ ODS objects one at a time.
For example, is there a SQL query for the database or perhaps an "RS" table ?
Thanks so much !