3

In my navicat, I want to add a field, but I think its value should be unique.

But in navicat, I can not find a way or option to choose, like Not Null or Character Set.

enter image description here

So, where is the unique option in Navicat for a field?

s-n-2
  • 405
  • 1
  • 6
  • 24

1 Answers1

13

It's available in Indexes tab.

enter image description here

Thanh Nguyen
  • 5,174
  • 11
  • 43
  • 74
  • does the Name, Fields, Index Type Index method will all write by me? – s-n-2 Mar 17 '17 at 09:39
  • Name is whatever you want. Fields is the field you want set index on. Index Type: Unique (as you expected). Index method: depends on your requirements. – Thanh Nguyen Mar 17 '17 at 09:42