Toad World® Forums

How to ignor constraint name generated by system


I reverse a model from an oracle database, and then compare the model with backup database. The oracle database generate a constraint name for any column not null, such as SYS_C009999. Then I always has the difference between the model and the backup database.

Is there any way to ignore the constraint name generated by system when I use toad modeler to compare the model with the backup database?


Hi mail8mz,

you can disable reverse it. Go to Option frame in RE wizard an uncheck "System Generated Name of Check and No Null Constraints". See screenshot

Regards Daril