Hi

EXEC sp_pkeys @table_name = tableName



>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.