Primary Key
Primary Key is a unique identifier of an individual row or record in a database table on SQL server. It is an attribute or a combination of attributes that uniquely identifies each row in the table. The primary key is crucial for ensuring data integrity and enables efficient querying, updating, and linking of data across different tables in the database on SQL server.
The Primary Key panel allows serchning and creating missing primary keys (PA indexes) on SQL server.
The functionality is accessed on Performance | Edit Indices panel in Administration panel.
The following is a description of the functionality of the form.
1.
 (Plus) |
By clicking, the following options are available:
- Collapse All - collapse whole fragmentation table.
- Expand All - expand whole fragmentation table.
- Collapse Selected - collapse only selected indices in fragmentation table.
- Expand Selected - expand only selected indices in fragmentation table.
- Collapse All for Selection - collapse all selected indices.
- Expand All for Selection - expand all selected indices.
- Select All - select all indices in fragmentation table.
- Undo Merge - restore to the original state before merging.
|
| Search |
By clicking, all indexes that are missing or redundant, will be collected. |
| Database |
Database where are missing PA indexes on SQL server. |
| Table |
Table where are missing PA indexes on SQL server. |
| Sel. |
By clicking, index is selected ( ). |
| Index |
Name of index. |
2.
| Create |
Create missing primary keys on SQL server. |