Author Topic: Which EA tables hold <<view>> Definition and Dependencies?  (Read 77 times)

Richard Freggi

  • EA User
  • **
  • Posts: 306
  • Karma: +11/-5
    • View Profile
Which EA tables hold <<view>> Definition and Dependencies?
« on: August 31, 2020, 11:28:26 pm »
I'm modeling some database views as classes using the <<view>> stereotype and it's nice that if I double click on the view, a menu comes up showing database, dependencies, definition (DML) and name of the view.

I'd like to access this info using SQL query on EA internal tables, can anyone advise which tables I can find them?  I don't see them in t_object or t_objectproperties.

qwerty

  • EA Guru
  • *****
  • Posts: 11402
  • Karma: +295/-263
  • I'm no guru at all
    • View Profile
Re: Which EA tables hold <<view>> Definition and Dependencies?
« Reply #1 on: September 01, 2020, 12:15:15 am »
Just "view" is found in the element's stereotype (t_object.stereotype). But you need to peek into t_xref.description/.client to find the FQN/object guid.

q.