Application Development Discussions
Join the discussions or start your own on all things application development, including tools and APIs, programming models, and keeping your skills sharp.
Showing results for 
Search instead for 
Did you mean: 

declaration of uniquefield in DDIC

Former Member
0 Kudos

hi experts,

i create an ztable for employee details...

in that i declare empcode and accessno fields as primary keys

while entering data it allows same access code for different employees

but i wan the accesscode field as a uniquekey... thus repitation of value in that field should not allowed... is there any option in DDIC for declaring particular field as unique field

ie if we declare more than one key as primary key it allows only one data for combination of that all primary key fields but allows repeated datas for a single field, is there any option to avoide that repetation for a prticular field.

thanks & regrds,



Active Contributor
0 Kudos

Hi arun,

although I do not understand why you need a second unique key if you already have one, I think it is possible to define the second 'key' as a normal table field and put a secondary unique index on this.