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