[Home] [Help]
View: EDW_FOREIGN_KEYS_MD_V
View Text
SELECT FK.OWNINGRELATION
, FK.CLASSNAME
, TBL.NAME
, FK.NAME
, FK.ELEMENTID
, FK.LONGNAME
, FK.DESCRIPTION
, UK.ELEMENTID
, UK.NAME
FROM CMPFOREIGNKEY_V FK
, CMPRELATION_V TBL
, CMPUNIQUEKEY_V UK
WHERE FK.OWNINGRELATION = TBL.ELEMENTID
AND FK.UNIQUEKEY = UK.ELEMENTID WITH READ ONLY
Columns
Name |
ENTITY_ID |
ENTITY_TYPE |
ENTITY_NAME |
FOREIGN_KEY_NAME |
FOREIGN_KEY_ID |
BUSINESS_NAME |
DESCRIPTION |
KEY_ID |
KEY_NAME |