Public Interface Export Function › Analysis Objects › Analysis Tasks Related to Data. › RELATIONSHIP (Relationship of an Entity Type or Subtype) › Task

Task

Select the from and to entity type names and the from and to relationship names. Order by from and to entity type name.

SELECT F.NAME, T.NAME, R.NAME, R.NAME_INVERSE
  FROM
  MODEL M,
  ENTITY_TYPE F,
  ENTITY_TYPE T,
  RELATIONSHIP R
  WHERE
  M.NAME = 'my model name'
  AND F.MODEL_ID = M.ID
  AND T.MODEL_ID = M.ID
  AND R.SOURCE_ENTITY_ID = F.ID
  AND R.DEST_ENTITY_ID = T.ID
ORDER BY F.NAME, T.NAME;