Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
How to pull out the PK field for the table
Message
From
12/09/2008 12:23:09
 
General information
Forum:
Microsoft SQL Server
Category:
Other
Environment versions
SQL Server:
SQL Server 2005
Miscellaneous
Thread ID:
01347071
Message ID:
01347105
Views:
15
This message has been marked as a message which has helped to the initial question of the thread.
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
Map
View

Click here to load this message in the networking platform