Additional Queries › Attributes › Attribute Description › Query for Attribute Description for Entity Types › Query for Attribute Description for Entity Subtypes

Query for Attribute Description for Entity Subtypes

SELECT M.NAME, M.CR_DATE, M.CR_TIME, M.CR_USERID, B.NAME, C.NAME,
 C.SEQ, C.OPT, C.TYPE, C.DOMAIN, C.LENGTH, C.DEC_PLACES, D.TEXT
 FROM
 MODEL M,
 ENTITY_SUBTYP B,
 ATTRIBUTE C,
 DESCRIPTION D
 WHERE M.NAME='my model name'
 AND M.ID=B.MODEL_ID
 AND B.ID=C.PARENT_Entity_ID
 AND C.ID=D.ID
 ORDER BY B.NAME, C.NAME;