Skip to Content (Press Enter)
2021-02-15 13-40-57
Shashank Diwan
373Views
2Comments
Solved
Define Column Unique
Question

Team,

Is there a way i can define a column Unique in the entity. I only found option for "Set as Identifier", but that is the Primary Key of the table, i want to use another column, do not need it to be Primary Key however want it to be unique.

One way is to handle it manually, but the is there a way to define Unique Constraint in the platform?

Please suggest.

Shashank...

0
0
06 Sep 2017
Copy Link
2018-11-06 14-26-44
Suraj Borade
Solution

Hello Shashank,

Double click on entity.

Go to Indexes

Click on New

Select Unique as Yes and after that attribute of table which you want to set as unique.

Hope this helps.

Thanks and Regards,

Suraj Borade

3
0
06 Sep 2017
Copy Link
2021-02-15 13-40-57
Shashank Diwan

Thanks Suraj.

I thinks thats the way to achieve it, there was one confusion but i got the information over the internet.

"Unique Index and Unique Constraint are the same. They achieve same goal. SQL Performance is same for both."


Shashank...

0
0
06 Sep 2017
Copy Link
Community GuidelinesBe kind and respectful, give credit to the original source of content, and search for duplicates before posting.