2 Replies Latest reply: May 31, 2012 8:18 AM by 938930 RSS

    Delete rule not generated in DDL

    938930
      Hello,

      I am using SQL Developer Data Modeler (Version 3.1.1.703) and experience the following issue:

      I have a table with a foreign key and a delete rule "SET NULL". However if I generate the DDL for "SQL Server 2005" then the rule is not there. Only if I change the rule to "CASCADE" then it is generated properly. Is that a bug or am I missing something?

      Thanks in advance for your help,
      Michael