topic Re: Primary key deletion in custom database table in Application Development and Automation Discussions

Primary key deletion in custom database table

Former Member — Mon, 06 Oct 2008 06:05:35 GMT

hi,

I've created a ztable.In which i've have created primary key and foreign key.

I've activated the table.Now my requirement is that i want to delete the primary key as i've shoosen wrong field as primary key.

For that first of all i deleted the foreign key relationship than i have unchecked the primary key but it is giving me an error.

even though if i deleted that field having primary key it is also giving me error as "Primary key change not permitted for value table.

Please help me out if possible.

waiting for ur response.

Thanks,

Dheeraj

Re: Primary key deletion in custom database table

Former Member — Mon, 06 Oct 2008 06:10:11 GMT

first check and see that no active abap object is using your ztable

then change the key fields and go to se14 to activate it

Re: Primary key deletion in custom database table

Former Member — Mon, 06 Oct 2008 06:17:17 GMT

Make sure u dont have any data in the table..u have to delete all the data..Also make sure you are not using that table any where else.do a where used list in the table.

Re: Primary key deletion in custom database table

Former Member — Mon, 06 Oct 2008 06:21:39 GMT

Hi muhammad,

How to use where used list in table.Please tell me

Thanks.

Dheeraj.

Re: Primary key deletion in custom database table

Former Member — Mon, 06 Oct 2008 06:29:52 GMT

IN SE11 TYPE TABLE NAME, LOCATE ICON WHERE USED IN APPLOCATION TOOL BAR, CHECK ALL CHECKBOXES AND EXECUTE