Skip to main content
Question

Schema Map - relationship between tables / views


Forum|alt.badge.img+9

Is anybody aware of a way of generating a IFSAPP schema map or (via SQL) a report that shows relationships between tables to tables / views to views?

 

2 replies

Forum|alt.badge.img+16
  • Superhero (Partner)
  • 446 replies
  • June 8, 2022

Hi

 

Here is relation between logical units:

select * from reference_sys_tab
 

Conjuction with dictionary_sys_view_tab might help to identify views connected with LU’s.


Forum|alt.badge.img+12
  • Hero
  • 217 replies
  • June 8, 2022

I believe one reason standard Oracle reporting tools can’t tell you much is that IFS does not use much by way of constraints, etc. Business rules and parent/child relationships are defined by the package API code. Right now I could go in and delete all records from CUSTOMER_INFO_TAB, making all CUSTOMER_INFO_ADDRESS records orphans -- no conditional key linkage would prevent that, as far as I can tell.

Good to know about the Reference_Sys table!

 

Thanks,

Joe Kaufman


Reply


Cookie policy

We use cookies to enhance and personalize your experience. If you accept you agree to our full cookie policy. Learn more about our cookies.

 
Cookie settings