Public Interface Export Function › Internal Design Objects › Access and Connection Objects › REL_PART_IMPL (Relationship or Partition Implementation) › Task

Task

Retrieve the entry points used for each entry point implementation technique, the record on which the entry point is defined, and the foreign key fields and their usage in the entry point.

SELECT IMP.ID, EP.NAME, REC.NAME, FK.NAME, EPF.SEQUENCE,
  EPF.SEQ
  FROM
  REL_PART_IMPL IMP,
  ENTRY POINT EP,
  RECORD REC,
  FIELD FK,
  FLD_ENTRY PT_USE EPF
  WHERE
  IMP.TECHNIQUE = 'E'
  AND EP.REL_IMPL_ID = IMP.ID
  AND EPF.ENTRY_POINT_ID = EP.ID
  AND FK.ID = EPF.FIELD_ID
  AND REC.ID = FK.RECORD_IS_IN_ID
ORDER BY IMP.ID, EP.NAME, EPF.SEQ;

Only many-to-many relationship memberships are implemented using the MN technique.