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