How to add an unique constraint or index ?

Click on the table which you want to add the unique constraint. Then, the table's properties panel will appear on the right.


Image 7

Figure 1. Table's properties panel.


Go to the Indexes group, and click on the add Icon (Figure 2). This will display the Index Properties panel as shown in the Figure 3.

Image 8

Figure 2. Add icon.

Image 9

Figure 3. Index properties panel.


Ensure to select Unique index type, and the columns that will be constrained (also the order of the columns). Check below the detailed process.


Image 10Animation 1. Adding unique constraint.


This article was helpful for 22 people. Is this article helpful for you?