Editing Index and Constraint Properties

Relationships (Foreign Keys) Tab

• In the Relationships (Foreign Keys) - General tab, you can edit the details of foreign key constraints.

Note! 1. When indexing is set to 'Enabled,' a foreign key index is automatically created when a foreign key constraint is added to a table.
2. + You can use the + button to establish a relationship with a unique key.



• In the Relationships (Foreign Keys) - Physical Properties tab, you can edit the ON DELETE/UPDATE behavior of relationships.

CHECK Constraint Properties Dialog

• In the Constraints tab, you can add or remove CHECK constraints and edit their details.

Note! MariaDB officially supports CHECK constraints starting from version 10.2.1.

Index / Constraint Properties Dialog

• In the Index tab, you can add or remove indexes and edit their properties.



• For non-unique indexes, you can specify the index type as BTREE, FULLTEXT, or SPATIAL.