Additional Queries › Entity Types › Entity Types Properties › Query for Entity Type Properties

Query for Entity Type Properties

SELECT M.NAME, M.CR_DATE, M.CR_TIME, M.CR_USERID, B.NAME
 B.DSD_NAME, B.MIN_OCCUR, B.MAX_OCCUR, B.AVG_OCCUR,
 B.GROWTH_RATE, B.GROWTH_RATE_PER
 FROM
 MODEL M,
 ENTITY_TYPE B,
 WHERE M.NAME='my model name'
 AND M.ID=B.MODEL_ID
UNION
SELECT M.NAME, M.CR_DATE, M.CR_TIME, M.CR_USERID
 B.NAME, B.DSD_NAME, B.MIN_OCCUR, B.MAX_OCCUR, B.AVG_OCCUR,
 B.GROWTH_RATE, B.GROWTH_RATE_PER
 FROM
 MODEL M
 ENTITY_SUBTYP B
 WHERE M.NAME='my model name'
 AND M.ID=B.MODEL_ID
ORDER BY M.NAME, B.NAME;