[Home] [Help]
View: EDW_FOREIGN_KEY_COLUMNS_MD_V
| Product: | BIS - Applications BIS |
|---|
| Description: | EDW_FOREIGN_KEY_COLUMNS_MD_V |
|---|
| Implementation/DBA Data: |
Not implemented in this database
|
|---|
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 |