>>>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.
>
>As far as i know
>Insert data returned by sp_pkeys in #temp and use in you query.

I guess the actual queries from sp_pkeys can be used to pull this info. I just need to view the text of this procedure. Thanks again.