Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
How to tell if FK relations are set to be enforced
Message
 
To
All
General information
Forum:
Microsoft SQL Server
Category:
Stored procedures, Triggers, UDFs
Title:
How to tell if FK relations are set to be enforced
Miscellaneous
Thread ID:
00871437
Message ID:
00871437
Views:
55
exec sp_fkeys @fktable_name=

Returns lots of information, but doesn't seem to include whether the checkboxes for whether or not to enforce the constraints:

"Enforce relationship for INSERTs and UPDATEs"

I don't see this in the SysObjects table. Anyone know how to get this information?

Thanks in advance!
Mike
Next
Reply
Map
View

Click here to load this message in the networking platform