The PRINT_FK stored procedure is used to display all the foreign keys to and from the specified table.
| Parameter | Description | |
|---|---|---|
| SCHEMA_NAME | Type: | INPUT |
| Datatype: | VARCHAR2(128) | |
| Default Value: | INUSER | |
| Description | The schema name that owns the table with the foreign keys being displayed. | |
| TABLE_NAME | Type: | INPUT |
| Datatype: | VARCHAR2(128) | |
| Default Value: | INUSER | |
| Description | The name of the table with the foreign keys being displayed. | |
Exceptions
Example
SET SERVEROUTPUT ON;
EXEC IN_DB_UTIL.PRINT_FK('INUSER','IN_DOC');
Example Output
Referential Integrity Constraints for the INUSER.IN_DOC table: INUSER.IN_DOC References: Foreign Key INUSER.FK_D_DOC_TYPE_ID References PK_DOC_TYPE is ENABLED and VALIDATED Foreign Key INUSER.FK_DOC_DRAWER_ID References PK_DRAWER is ENABLED and VALIDATED Foreign Key INUSER.FK_DOC_INSTANCE_ID References PK_INSTANCE is ENABLED and VALIDATED INUSER.IN_DOC Referenced By: Table INUSER.IN_DOC_CONTENT Foreign Key FK_DC_DOC_ID References PK_DOC is ENABLED and VALIDATED Table INUSER.IN_DOC_KW Foreign Key FK_DK_DOC_ID References PK_DOC is ENABLED and VALIDATED Table INUSER.IN_RC_RECORD_DOC Foreign Key FK_RCRD_D_ID References PK_DOC is ENABLED and VALIDATED Table INUSER.IN_SIG Foreign Key FK_S_DOC_ID References PK_DOC is ENABLED and VALIDATED Table INUSER.IN_TASK Foreign Key FK_T_DOC_ID References PK_DOC is ENABLED and VALIDATED Table INUSER.IN_VERSION Foreign Key FK_V_DOC_ID References PK_DOC is ENABLED and VALIDATED PL/SQL procedure successfully completed.