General information
Forum:
Microsoft SQL Server
Environment versions
SQL Server:
SQL Server 2005
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.
Previous
Next
Reply
View the map of this thread
View the map of this thread starting from this message only
View all messages of this thread
View all messages of this thread starting from this message only