>>>>Hi,
>>>>
>>>>How can I modify the following EXISTS expression that will tell me if FK constraint has UPDATE clause set? For example, I can use the following expression that will tell me if FK constraint exists. But I need to know if UPDATE clause exists.
>>>>
>>>>

>>>>IF EXISTS (SELECT * FROM sys.objects WHERE object_id = OBJECT_ID(N'[dbo].[FK_tablename_field_name]') AND
>>>>		parent_object_id = OBJECT_ID(N'[dbo].[tablename]'))
>>>>
>>>>

>>>>
>>>>TIA.
>>>
>>>Instead of sys.objects use sys.foreign_keys :-)
>>>Look into the set it returns and will see that is has all info about FK constraint.
>>
>>Yes, it looks like sys.foreign_keys has all that I need. Thank you!
>>
>>One thing, if you could explain please. The query has column object_id and it shows a long string of numbers. Yet in the SQL Select (above example) I say "find me the record where the object_id = 'name_of_fk_constrain'". How does it works? The NAME column of the query actually has the FK constraint name and not object_id. What I am trying to say is that code works but I can't understand how.
>
>
>If you check sys.foreign_keys in BOL you will see that the first columns are inherited from sys.objects.

Thank you very much!