Options

WITH NOCHECK issue

wkhazzardwkhazzard Posts: 20
edited April 25, 2011 4:06PM in SQL Compare Previous Versions
If you create a foreign key using ALTER TABLE ... WITH CHECK ADD CONSTRAINT in one database and in another database you create the same key using ALTER TABLE ... WITH NOCHECK ADD CONSTRAINT followed by an ALTER TABLE ... CHECK CONSTRAINT statement to enable the key, why does SQL Compare see them as different?

I understand that the creation metadata for the keys are different. But I don't care about that. I only care (a) does the key exist in both databases, (b) does it have the same definition and (c) do the enabled flags match?

Is there a filter or other setting in SQL Compare to give me what I want?

Thanks,
Kevin Hazzard, C# MVP & Friend of Red Gate
http://devjourney.com

Comments

Sign In or Register to comment.