Friday 15 July 2011

key - "SET FOREIGN_KEY_CHECKS = 0;" Oracle Equivalent -


Is MyScall like the specific instruction that disables the detection of foreign key constraints?
SET FOREIGN_KEY_CHECKS = 0;

There is no order in Oracle, Will disable.

Though it seems that you want to disable the barriers in relation to leaving the table. In that case, you can use the table with the exception of excluding barriers referred to from other tables and leaving the table.

Here is an example:

  SQL & gt; Create table T1 (ID number primary key); Table sql and gt; Create table T2 (ID number reference T1); Table sql and gt; Insert T1 value (1); 1 line sql and gt; Insert T2 value (1); 1 line sql and gt; - This foreign key fails due to SQL and GTA; Drop table t1; ORA-02449: unique / primary key in the table referenced by the foreign key is SQL & gt; Drop Table T1 Cascade Constants; Dropped table    

No comments:

Post a Comment