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

Task

Select all entity types and their attributes from model 'my model.' Order entity types by name. Order attributes as they are in the diagram.

SELECT E.NAME, A.NAME, A.LENGTH, A.DOMAIN, A.SEQ
  FROM
  MODEL M,
  ENTITY_TYPE E,
  ATTRIBUTE A
  WHERE
  M.NAME = 'my model name'
  AND E.MODEL_ID = M.ID
  AND A.PARENT_ENTITY_ID = E.ID
ORDER BY E.NAME, A.SEQ;