Embedded Files
Oracle
Show
Show
OWNER CONSTRAINT_NAME C CONTRAINT_TYPE TABLE_NAME R_OWNER R_CONSTRAINT_NAME DELETE_RU INDEX_OWNER INDEX_NAME-------- ---------------- - ------------------ -------------------- --------- --------------------- --------- ------------- ------------------------------MYUSER MYTABLE1_UK1 U Unique Key MYTABLE1 MYUSER MYTABLE1_UK1MYUSER MYTABLE1_PK P Primary Key MYTABLE1 MYUSER MYTABLE1_PKMYUSER SYS_C00371656 C Check Constraint MYTABLE1 MYUSER SYS_C00371657 C Check Constraint MYTABLE1 MYUSER SYS_C00371658 C Check Constraint MYTABLE1 MYUSER SYS_C00371659 C Check Constraint MYTABLE1 MYUSER SYS_C00371660 C Check Constraint MYTABLE1 MYUSER MYTABLE1_FK1 R Referential MYTABLE1 MYUSER MYTABLE2_PK NO ACTIONMYUSER MYTABLE1_FK2 R Referential MYTABLE1 MYUSER MYTABLE3_PK NO ACTION
Check Constraints
Check Constraints
OWNER CONSTRAINT_NAME TABLE_NAME SEARCH_CONDITION-------- ------------------------------ ------------------------------- --------------------------------------------------------------------------------MYUSER SYS_C00371656 MYTABLE1 "MYCOLUMN1" IS NOT NULLMYUSER SYS_C00371657 MYTABLE1 "MYCOLUMN2" IS NOT NULLMYUSER SYS_C00371658 MYTABLE1 "MY_TAB2_FK" IS NOT NULLMYUSER SYS_C00371659 MYTABLE1 "MI_TAB3_FK" IS NOT NULLMYUSER SYS_C00371660 MYTABLE1 "MI_TAB4_PK" IS NOT NULL
Referential Integrity Constraints
Referential Integrity Constraints
OWNER CONSTRAINT_NAME CONTRAINT_T TABLE_NAME R_OWNER R_CONSTRAINT_NAME DELETE_RU INDEX_OWNER INDEX_NAME-------- -------------------- ----------- ----------------- --------- ------------------------------ --------- -------------- ------------------------------MYUSER MYTABLE1_UK1 Unique Key MYTABLE1 MYUSER MYTABLE1_UK1MYUSER MYTABLE1_PK Primary Key MYTABLE1 MYUSER MYTABLE1_PKMYUSER MYTABLE1_FK1 Referential MYTABLE1 MYUSER MYTABLE2_PK NO ACTIONMYUSER MYTABLE1_FK2 Referential MYTABLE1 MYUSER MYTABLE3_PK NO ACTION
OWNER CONSTRAINT_NAME CONTRAINT_T TABLE_NAME R_OWNER R_CONSTRAINT_NAME DELETE_RU INDEX_OWNER INDEX_NAME-------- -------------------------- ----------- ------------------------------ -------- ------------------ --------- ------------ --------------------------MYUSER MYTABLE2_FK2 Referential MYTABLE2 MYUSER MYTABLE1_PK NO ACTION
OWNER CONSTRAINT_NAME CONTRAINT_T TABLE_NAME R_OWNER R_CONSTRAINT_NAME DELETE_RU INDEX_OWNER INDEX_NAME-------- ------------------------------ ----------- ------------------------------ -------- ------------------ --------- ------------ ----------------------MYUSER MYTABLE2_FK2 Referential MYTABLE2 MYUSER MYTABLE1_PK NO ACTIONMYUSER MYTABLE3_FK2 Referential MYTABLE3 MYUSER MYTABLE1_PK NO ACTIONMYUSER MYTABLE4_FK2 Referential MYTABLE4 MYUSER MYTABLE1_PK NO ACTIONMYUSER MYTABLE5_FK2 Referential MYTABLE5 MYUSER MYTABLE1_PK NO ACTIONMYUSER MYTABLE6_FK2 Referential MYTABLE6 MYUSER MYTABLE1_PK NO ACTIONMYUSER MYTABLE7_FK Referential MYTABLE7 MYUSER MYTABLE1_PK NO ACTION
Unindexed Foreign Keys
Unindexed Foreign Keys
Unindexed foreign keys can often have a negative impact on performance.
OWNER TABLE_NAME CONSTRAINT_NAME COLUMNS------------------------------ ------------------------------ ------------------------------ --------------------------------------------------SCOTT EMP FK_DEPTNO DEPTNO
APEX report - unindexed foreign keys
Bibliography
Bibliography
Page updated
Google Sites
Report abuse