I am using DMO to create tables and primary keys. When I profile the server, I see that the primary key is created with a CHECK constraint. This must be the default because I am not setting this in my code.
I would like to generate a line of code like this:
ALTER TABLE tablename WITH NOCHECK ADD CONSTRAINT and so on......
instead of
ALTER TABLE tablename WITH CHECK ADD CONSTRAINT and so on.....
I see that the key object has a "Checked" property which I set to false, but I am not sure where to put the line of code.
Thanks for your help.