DOO_PC_FKEYS_V

Details

• Schema: FUSION

• Object owner: DOO

• Object type: VIEW

Columns

Name
MODULE_ID DB_OBJECT_NAME DB_OBJECT_TYPE FOREIGN_KEY_NAME UNIQUE_KEY_NAME UK_MODULE_ID UK_DB_OBJECT_NAME

Query

SQL_Statement
SELECT fk.MODULE_ID, fk.DATABASE_OBJECT_NAME db_object_name, 'VIEW' AS DB_OBJECT_TYPE, fk.FOREIGN_KEY_NAME, fk.UNIQUE_KEY_NAME unique_key_name, uk.MODULE_ID uk_module_id, uk.DATABASE_OBJECT_NAME uk_db_object_name FROM DOO_FOREIGN_KEYS fk, DOO_UNIQUE_KEYS uk WHERE fk.UNIQUE_KEY_NAME = uk.UNIQUE_KEY_NAME