Sparx Systems Forum

Enterprise Architect => General Board => Topic started by: bholtzman on November 16, 2018, 02:22:49 am

Title: Where are parent relationships in the database?
Post by: bholtzman on November 16, 2018, 02:22:49 am

Hi:
I've been asked to compile all of the parent relationships ("Set Parents and Interfaces" popup) that have been entered into an EA database. I've done some testing and then scoured the database to find the change but no luck. Could someone tell me the table and field where this information is stored? Thank you.

Bill

Title: Re: Where are parent relationships in the database?
Post by: qwerty on November 16, 2018, 02:44:46 am

Where does that popup pop up?

q.

Title: Re: Where are parent relationships in the database?
Post by: bholtzman on November 16, 2018, 02:53:07 am

Click on an object (class) and then Advanced and Parent. Sure wish we could post pictures here.

Title: Re: Where are parent relationships in the database?
Post by: bholtzman on November 16, 2018, 02:59:11 am

That should've said right-click on an object and then Advanced...

Title: Re: Where are parent relationships in the database?
Post by: Geert Bellekens on November 16, 2018, 04:36:18 am

Code: [Select]

select * from t_connector c where c.connector_Type = 'Generalization'
Geert

Title: Re: Where are parent relationships in the database?
Post by: bholtzman on November 16, 2018, 05:01:30 am

Thank you, Geert. You are the guru!

Bill