On the Indexes tab of Visual FoxPro Table Designer dialog, you can define a Primary Index. How do I do the same thing through code in a FoxPro program?
You need to use the ALTER TABLE command. What follows is the code to create a database called bobo with a table called mydbf, with a primary key called cName:
CREATE DATA Bobo
create table mydbf (cName C(10),nAge N(3))
ALTER TABLE MYDBF ADD PRIMARY KEY cName TAG cName