constraint status validate/novalidate

[vb.de]

On the table editor I can see the different constraints (not null, foreign key and check). I can see and set if they are enabled too. But what I could not see and set is if they are validated or not.
Is there a special setting in the configuration to see and set this constraint attribute? Then please tell me.
If not, please add as soon as possible.

This and the missing partition options are the only reasons I have to use TOAD from time to time.

 

[Marco Kalter]

You can see extra constraint properties by right-clicking on them in the Object Browser and selecting "Properties".

 

[vb.de]

I found it in the properties windows, thanks,
But the table editor with the tabs Columns, Keys and Checks would be a much better place and a better overview what's going on. With an validate/novalidate column on those tabs you can also generate the ddl statements more easily.

Now for example I see a column as nullable, when the system constraint is enabled but not validated. When I generate the tablescript with 'view sql' the constraint is missing. That's a fault.

 

[vb.de]

Hi Marco,

is it planed to add a validate/novalidate column to the constraints in the table editor in the next release?
If not, could you please add it to the list of enhancement request.

Thanks

 

[Marco Kalter]

It is not planned for the next release, but I have added this to the list of enhancement requests.