[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 |