Does JDE allow unique index?

[Andrew2009]

I have a table that have 10 columns and I want to make sure the combination of these 10 columns are unique. I could make them all primary keys, that will ensure uniqueness. Or the other way is to create a unique index.

Can you create a unique index in JDE?

Thanks

JDE 9.1

 

[nkuebelbeck]

yes. TDA

https://docs.oracle.com/cd/E17984_01/doc.898/e14702/designingtables.htm

"A unique index is marked with a single key. You can right-click the index and select Unique from the Index menu to toggle the unique status. The Unique Primary Index cannot be changed to a non-unique status."