Tables > File Restructuring > Primary Key Set/Delete

Setting/Deleting Paradox Primary Key from Table menu

Setting a Primary Index

As the Paradox and dBASE 7 Primary Key index cannot be added to existing tables via Local SQL, this function has been added to the Table menu (utilizing a BDE API function).

For Paradox tables PdxEditor lets you add either a single first field primary key or a compound first & second field primary key.
Due to the Paradox rules, a primary key always have to include the first field/column, and if applying a compound primary key, the successive field(s) must be consecutive.

Other indexes

If adding a secondary Paradox UNIQUE index, the table must have an existing primary key.

Setting and clearing other types of indexes, whatever on Paradox, dBASE or FoxPro tables, are done with SQL executed from the SQL Editor.