[Home] [Help]
View: EDW_PVT_COLUMNS_MD_V
View Text
SELECT ITEM.ELEMENTID COLUMN_ID
, ITEM.NAME COLUMN_NAME
, ITEM.OWNINGRELATION PARENT_OBJECT_ID
, DATA.NAME DATA_TYPE
, ITEM.LENGTH LENGTH
, ITEM.LONGNAME LOGICAL_NAME
, ITEM.DESCRIPTION DESCRIPTION
FROM CMPITEM_V ITEM
, CMPDATATYPE_V DATA
WHERE DATA.ELEMENTID=ITEM.DOMAIN
Columns
Name |
COLUMN_ID |
COLUMN_NAME |
PARENT_OBJECT_ID |
DATA_TYPE |
LENGTH |
LOGICAL_NAME |
DESCRIPTION |