[Home] [Help]
View: OE_PC_FKEYS_V
View Text
SELECT FK.APPLICATION_ID
, FK.DATABASE_OBJECT_NAME DB_OBJECT_NAME
, 'VIEW' DB_OBJECT_TYPE
, FK.FOREIGN_KEY_NAME
, FK.UNIQUE_KEY_NAME UNIQUE_KEY_NAME
, UK.APPLICATION_ID UK_APPLICATION_ID
, UK.DATABASE_OBJECT_NAME UK_DB_OBJECT_NAME
FROM AK_FOREIGN_KEYS FK
, AK_UNIQUE_KEYS UK
WHERE FK.UNIQUE_KEY_NAME = UK.UNIQUE_KEY_NAME
Columns
Name |
APPLICATION_ID |
DB_OBJECT_NAME |
DB_OBJECT_TYPE |
FOREIGN_KEY_NAME |
UNIQUE_KEY_NAME |
UK_APPLICATION_ID |
UK_DB_OBJECT_NAME |