Selecting from DBC.DISTINCT_RI_PARENTS gives me a list of all foreign key constraints in the database. But it doesn't show me which of the constraints have WITH NO CHECK OPTION specified and which do not. Currently, I'm using SQL Assistant to manually do Show Definition for each table (one by one) to see which FK constraints have WITH NO CHECK OPTION (some do, some don't). Instead, I'd like to run a single query to show me all this, if possible. Thanks!
There's no way to get that info from the dbc tables/views, this is only stored in the table header :-(