Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

Register Log in
  • Congratulations sizbut on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

FK Relationship property via INFORMATION_SCHEMA...

Status
Not open for further replies.
bmgmzp

bmgmzp

Programmer
Aug 18, 2006
84
US
Notice the screen shot I included... does anybody know how to access the "Enforce Foreign Key Constraint" property from the INFORMATION_SCHEMA?

I would like to be able to write a piece of T-SQL that will show me all the relationships where "Enforce Foreign Key Constraint" is set to "No".

707952808_b5d8ee3055.jpg


Thanks
 
Status
Not open for further replies.

Similar threads

Andrzejek
  • Locked
  • Question
PK-FK Relations
Replies
10
Views
520
Chris Miller
Chris Miller
xarzu
  • Locked
  • Question
How do I produce the relationship diagram in Microsoft Sql Server?
Replies
1
Views
406
Andrzejek
Andrzejek
ElEye
  • Locked
  • Question
Parse XML via SQL query 1
Replies
1
Views
171
gmmastros
gmmastros
BxWill
  • Locked
  • Question
TSQL - Create Foreign Keys - Error: There is already an object named FK_EquipMaster" 2
Replies
8
Views
301
Olaf Doschke
Olaf Doschke
RRinTetons
  • Locked
  • Question
Anybody integrating with ASP via the Workforce API's?
Replies
3
Views
109
jbenson001
jbenson001

Part and Inventory Search

Sponsor

Back
Top