Question:
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?
Answer:
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 Bobocreate table mydbf (cName C(10),nAge N(3))ALTER TABLE MYDBF ADD PRIMARY KEY cName TAG cName