How to pull out the PK field for the table

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:25:49

Naomi Nosonovsky
Wisconsin, United States

12/09/2008 12:23:09

Zahid Mashhood
Techtrix
Karachi, Pakistan

General information

Forum:

Microsoft SQL Server

Category:

Other

Title:

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

Environment versions

SQL Server:

SQL Server 2005

Miscellaneous

Thread ID:

01347071

Message ID:

01347106

Views:

>Hi
>
>EXEC sp_pkeys @table_name = tableName
>
>

Is it the only way? I want to create a query, how would I use this sp in a query? I'm not on a computer with SQL Server, can't test at the moment.

If it's not broken, fix it until it is.

My Blog

Map

View

Click here to load this message in the networking platform