Hi All,

I am writting a stored procedure where I want to determine the PK of a table. It seems that sp_pkeys is just the ticket. However, this SP returns a result set, with a column named 'COLUMN_NAME' that contains the PK name.

If I call sp_pkeys in a stored procedure, how can I access the result set it returns to get the value of column name?

Thanks,
BOb