We created several tables in previous sections, but never defined primary keys. This means that the development environment decided which fields to use for primary keys for us. In C/SIDE, the first field in the table automatically becomes its primary key and the clustered index. Now we will review and adjust primary keys and define indexes that will help us improve application performance.
Defining the primary key and secondary indexes
Defining primary keys
When a new table is created, the primary key is created automatically by the Object Designer. The first field defined in the table is assigned as the single primary key field. This is not always the primary key the developer means for the table. Let's see how to change...