sql - How can I temporarily disable constraints on my table? -


after going through this post, trying add following command in stored procedure:

alter table mytable nocheck constraint 

but editor underlines , shows error:

sql70005: option cannot used modify constraints. must use individual constraint names instead 

i'm using vs2013 express web sql server 2008 r2 express. missing here?

you can write script generate statements disable each 1 (and hten re-enable appropriate.


Comments

Popular posts from this blog

java - Intellij Synchronizing output directories .. -

git - Initial Commit: "fatal: could not create leading directories of ..." -