I’m having an issue when generating an SQL schema in Toad. In the “Relationship” menu, under the “Referential Integrity” tab, I’ve selected the value “Set NULL” (previously ‘Restrict’) for the Parent - Delete option. I can save this, and the change will be remembered when I open up the model on subsequent launches of Toad. However, when I regenerate the corresponding SQL, there aren’t any changes made for this new constraint.
Any ideas as to what’s going on? Why the changes made to the toad model aren’t being reflected in the generated SQL? I can of course make this change by hand, but on subsequent SQL regens, my change will be wiped out.
Product Name: Toad Data Modeler
File version: 22.214.171.124
Template version: 2.29