Toad World® Forums

Converting model, attribute with wrong properties


Hallo !

For testing purposes i used the videorental model and converted it to a new oracle 10g model. Making the compare (generate alter script) shows differences in the model.

In the new model, the filed t_exemplar.price_per_day has the “not null” attribute set.



Hi Reiner,

this is not a bug. This is a result of custom settings.
Click Settings | Options and in section Model | Physical Model you can check or uncheck check box Allow Null Attributes in Keys. Check this checkbox if you want to have keys nullable (otherwise the application will force notnull setting).

Try to change that settings and then do the comparison again. You will see no differences between the two models then.