General information
Forum:
Microsoft SQL Server
Category:
Stored procedures, Triggers, UDFs
Title:
How to tell if FK relations are set to be enforced
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
View the map of this thread
View the map of this thread starting from this message only
View all messages of this thread
View all messages of this thread starting from this message only