fk check

Last Post 16 Aug 2010 09:06 AM by russellb. 3 Replies.
AddThis - Bookmarking and Sharing Button Printer Friendly
  •  
  •  
  •  
  •  
  •  
Sort:
PrevPrev NextNext
You are not authorized to post a reply.
Author Messages
dbandee
New Member
New Member

--
12 Aug 2010 05:15 AM
good morning all

i check a few tables in my db and the option "Enforce Foreign Key Constraint" is set to no

i have a few hundred tables db, how do i check for this setting on all tables?

Thanks
russellb
New Member
New Member

--
12 Aug 2010 10:24 AM
select object_name(parent_object_id) [table], name fk, is_disabled from sys.foreign_keys
dbandee
New Member
New Member

--
16 Aug 2010 05:21 AM
thank you!!!
russellb
New Member
New Member

--
16 Aug 2010 09:06 AM
Welcome
You are not authorized to post a reply.

Acceptable Use Policy