Toad World® Forums

Constraints


#1

Hi All,

Is there a way to add WITH NOCHECK constraints? I’ve been playing around with entity check constraints and attributes check constraints and I can’t seem to figure it out.

Thanks


#2

alter table tabname with nocheck check constraint checkname

go

Hi,

we guess you work with MS SQL Server. The WITH NOCHECK option is not recommeded, however, if you wish to get it generated, add the following statement to After Script tab.

Note: this will not be loaded during Reverse Engineering.

Regards,

Vaclav & TDM team