Checking indexes and primary keys

Once you have set the indexes and primary key for a table, you can check them by clicking on the Index button in the "New Table" or "Format Table" dialog. In the Table Indexes box all the indexes set for a particular table are listed:

To check what kind of index has been set for a field, click anywhere in that field's row in the Table Indexes box. The two check boxes at the bottom of the dialog - Primary Key and Unique - will be activated. Together these enable you to determine the kind of index set for each field:

For information on how to set indexes in the Table Indexes box, see Editing and setting indexes and primary keys.