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.
cancel
Turn on suggestions
Auto-suggest helps you quickly narrow down your search results by suggesting possible matches as you type.
Showing results for 
Search instead for 
Did you mean: 

how to change unique to non unique key.?

Go to solution
Former Member

‎09-01-2006 4:44 PM

0 Kudos

i like to know how to change a unique key to non unique key in tables..? if anyone knows pls answer...

1 ACCEPTED SOLUTION

Go to solution
Former Member

‎09-01-2006 4:46 PM

0 Kudos

in change mode in SE11,

select the check box KEY to make that field as KEY and DESELECT it to remove it from KEY.

but all KEYS should be at the beginning of the table. after other fields should be defined.

Regards

srikanth

Message was edited by: Srikanth Kidambi

4 REPLIES 4

Go to solution
Former Member

‎09-01-2006 4:46 PM

0 Kudos

in change mode in SE11,

select the check box KEY to make that field as KEY and DESELECT it to remove it from KEY.

but all KEYS should be at the beginning of the table. after other fields should be defined.

Regards

srikanth

Message was edited by: Srikanth Kidambi

Go to solution
Former Member

‎09-01-2006 4:49 PM

0 Kudos

In internal tables, add the syntax "WITH NON-UNIQUE KEY"

In Database tables, you do not. Some DB engines do not support. Regardless, it is a BAD idea.

Go to solution
Former Member
In response to Former Member

‎09-01-2006 4:50 PM

0 Kudos

As a rule... regardless of whether or not the DB engine allows you to create DB tables without primary keys.. you should not. Can not repeat that enough.

Go to solution
Former Member

‎09-01-2006 4:49 PM

0 Kudos

Hi,

goto se11,in the change mode deselect the <b>key check box</b> of that field in the table.

Regards,

Sowjanya