Class and its realised Interface - SQL query

[Evandro]

Hi there, I'm trying to query my model in order to get a table with two columns: on with the name of the class and the other with name of the interface realised by the class. First of all, is there a built-in search of this kind or should I build a custom SQL query? In this second case, has anyone done anything similar before? Should I use End_Object_ID and Start_Object_ID of the t_connector table?

Thanks

[qwerty]

Yes, you need the t_connector table WHERE connector_type = "Realisation" and JOIN t_object AS o1 WHERE o1.object_id = Start_Object_ID (or if your EAP gets hickups on JOIN just a plain WHERE.

q.