This page of the wizard of adding an EDB base table serves for defining a primary key of the table being created. Such a key provides unique identifiability of each record.
Primary key presence | Checkbox indicating whether any primary key is defined for the given table. |
Primary key properties | Available columns – a list containing all columns (fields) of the table which are not included into primary key. Key columns – a list containing those columns which constitute the primary key. Buttons > and < serve to move table columns from the list of available columns to the list of key columns and vice versa. Button << cleans the list of key columns (i.e. it moves all columns to the list of available columns). Buttons Up and Down allows changing order of columns in the primary key. Field Constraint name allows specifying a name for the primary key. This name can be used later for manual composing SQL expressions for processing the table. |
Adding EDB table as a base table in data source