How to pull out the PK field for the table

Plateforme Level Extreme

Abonnement

Profil corporatif

Produits & Services

Support

Légal

English

How to pull out the PK field for the table

Message

12/09/2008 12:45:56

Sergey Berezniker
New York, États-Unis

12/09/2008 12:39:25

Zahid Mashhood
Techtrix
Karachi, Pakistan

Information générale

Forum:

Microsoft SQL Server

Catégorie:

Autre

Titre:

Re: How to pull out the PK field for the table

Versions des environnements

SQL Server:

SQL Server 2005

Divers

Thread ID:

01347071

Message ID:

01347114

Vues:

This message has been marked as the solution to the initial question of the thread.

>As far as i know
>Insert data returned by sp_pkeys in #temp and use in you query.

There're other ways. See Message #796855, for example. I'm pretty sure that in SQL 2005 one of sys system views should have this info as well.

--sb--

Répondre

Fil

Voir

Click here to load this message in the networking platform