About Trusted Foreign Key Contraints

I will post some of my findings about trusted foreign keys and constants here since this has become a minor issue at work. First we need to see if we have any untrusted foreign key constraints. We can see them by running the following query:

(more to come)

References

Can you trust your constraints?

Blitz Result: Foreign Keys or Check Constraints Not Trusted

ALTER TABLE CHECK CONSTRAINT

Views – 590