Please start any new threads on our new site at https://forums.sqlteam.com. We've got lots of great SQL Server experts to answer whatever question you can come up with.

All Forums  SQL Server 2005 Forums  Transact-SQL (2005)  "Check Existing Data On Creation or Re-enabling"

Author  Topic  kosmas Starting Member 3 Posts Posted - 2008-06-11 : 08:35:09 the statment select FK.name, FK.is_disabled from sys.foreign_keys FK returns the "Enforce Foreign Key Constraint" attrubute of the foreing key. How I can find the attribute "Check Existing Data On Creation or Re-enabling" for one given foreign key ?