To delete primary index I use command: ALTER TABLE 'MyTable' DROP PRIMARY KEY
However, MyTable.DBF has other regular and candidate indexes
created with commands: INDEX ON field1 TAG field1
INDEX ON field2 TAG field2 CANDIDATE

How can I delete a regular or candidate index programmaticaly( not manually!!)?

TIA
Ed