[Home] [Help]
View: EDW_ALL_COLUMNS_MD_V
View Text
SELECT REL.ELEMENTID
, REL.CLASSNAME
, REL.NAME
, ITEM.ELEMENTID
, ITEM.NAME
, ITEM.LONGNAME
, ITEM.DESCRIPTION
, ITEM.POSITION
, DATA.NAME
, ITEM.LENGTH
FROM CMPITEM_V ITEM
, CMPRELATION_V REL
, CMPDATATYPE_V DATA
WHERE ITEM.OWNINGRELATION = REL.ELEMENTID
AND ITEM.DOMAIN = DATA.ELEMENTID WITH READ ONLY
Columns
Name |
ENTITY_ID |
ENTITY_TYPE |
ENTITY_NAME |
COLUMN_ID |
COLUMN_NAME |
BUSINESS_NAME |
DESCRIPTION |
POSITION |
DATA_TYPE |
LENGTH |