Primary keys are created using the " Create a Primary Key" command on a table.
The following properties can be defined for a primary key in the SQL tab:
-
Name: Name of the primary key
-
Key: Indicates the type of the attribut (PrimaryKey)
-
Type: The SQL type of the primary key
-
Default value: A default value for the primary key (editable field)
-
Not null: The SQL NOT NULL property
-
Autogenerated: The SQL AUTO_INCREMENT property
-
Unique: The SQL UNIQUE property
-
Null: The SQL NULL property
-
Check: The SQL CHECK property