[Home] [Help]
View: EDW_FOREIGN_KEY_COLUMNS_MD_V
View Text
SELECT REL.ELEMENTID
, REL.CLASSNAME
, REL.NAME
, FK.NAME
, FK.ELEMENTID
, FK.LONGNAME
, FK.DESCRIPTION
, PK.ELEMENTID
, PK.NAME
, FK_ITEM.ELEMENTID
, FK_ITEM.NAME
, FK.POSITION
FROM CMPRELATION_V REL
, CMPFOREIGNKEY_V FK
, CMPWBITEMSETUSAGE_V FKISU
, CMPITEM_V FK_ITEM
, CMPRELATION_V P_REL
, CMPUNIQUEKEY_V PK
WHERE FK.OWNINGRELATION=REL.ELEMENTID
AND FKISU.ITEMSET=FK.ELEMENTID
AND FK_ITEM.ELEMENTID=FKISU.ATTRIBUTE
AND PK.ELEMENTID=FK.UNIQUEKEY
AND P_REL.ELEMENTID=PK.OWNINGRELATION WITH READ ONLY
Columns
Name |
ENTITY_ID |
ENTITY_TYPE |
ENTITY_NAME |
FK_NAME |
FK_ID |
FK_LOGICAL_NAME |
FK_DESCRIPTION |
PK_ID |
PK_NAME |
FK_COLUMN_ID |
FK_COLUMN_NAME |
FK_POSITION |