Hi everybody,

I want to create a script that would check all my tables with character long (>100 char) fields for a certain word in them. If this word is found then I want to update this table based on its primary key from another "clean" table.

My current problem is to get PK field for each table I identified in my query. I looked into sys.indexes, but It doesn't return the actual field name.

Any ideas how can I get the information?

Thanks a lot in advance.