You're welcome.
>Thanks! That will work for me.
>...douglas
>
>>There's no VFP function but you can use sp_pkeys system sproc.
USE pubs
>>EXEC sp_pkeys 'authors'
>>
>>>I am dynamically generating a vfp views database based on a sql server database. I am using the vfp functions - SQLTables() and SQLColumns() to extract the tables and their schema. However, the data returned does not indicate which of the fields/columns is the table's primary key. Does anyone know of a way to determine the PK of a sql server table via a vfp function?
>>>
>>>Thanks,
>>>Douglas
--sb--