Book a Demo

Author Topic: Reverse DB result: views dependencies & Parents tag  (Read 3896 times)

Guillaume

  • EA Practitioner
  • ***
  • Posts: 1405
  • Karma: +42/-2
    • View Profile
    • www.umlchannel.com
Reverse DB result: views dependencies & Parents tag
« on: April 27, 2018, 01:48:45 am »
Hi,

I ran a DB Reverse on a SQL Server that has tables and views.
I'm interested in the link between views and the data sources i.e. tables ; I understand this is stored in the parents tagged value with a comma-separated list of table names.

I couldn't find in the user guide what the dependency links from Views to Tables mean. Anyone has an idea?
Ideally I'd like to have links from views to the table sources which I can get via a script.

Guillaume

Blog: www.umlchannel.com | Free utilities addin: www.eautils.com


qwerty

  • EA Guru
  • *****
  • Posts: 13584
  • Karma: +397/-301
  • I'm no guru at all
    • View Profile
Re: Reverse DB result: views dependencies & Parents tag
« Reply #1 on: April 27, 2018, 06:00:27 am »
Just from a guess: a view bundles a number of tables (resp. their contents) and is thus dependent on these views.

q.

Guillaume

  • EA Practitioner
  • ***
  • Posts: 1405
  • Karma: +42/-2
    • View Profile
    • www.umlchannel.com
Re: Reverse DB result: views dependencies & Parents tag
« Reply #2 on: April 27, 2018, 05:25:06 pm »
Having given it more thoughts and compared the "parents" tag + dependencies with the viewdef tag content, I may have identified a potential solution:
- parents tag lists all tables and views used by the view based on the FROM clause (incl. joins)
- dependencies match the tables and views involved in the SELECT clause i.e. at least one column appears in the view results/content

Guillaume

Blog: www.umlchannel.com | Free utilities addin: www.eautils.com