>>>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.
Against Stupidity the Gods themselves Contend in Vain - Johann Christoph Friedrich von Schiller
The only thing normal about database guys is their tables.