How to ignor constraint name generated by system

Toad Data Modeler
1

Hi,

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?

Thanks!

2

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

SystemGeneratedNameOfCheckanNotNull.jpeg
SystemGeneratedNameOfCheckanNotNull.jpeg686×700 83.8 KB

Regards Daril