Skip to Content
avatar image
Former Member

Issues while changing primary key in table

Hi

I have one table. In that two fields are primary key. I want to change the second PK as FK only. But when i am changing this field as FK. Its showing one error 'Primary Key Change not permitted for value Table ZCAUSECATMASTER' . How to avoid this error.

Please help me.

Add comment
10|10000 characters needed characters exceeded

  • Get RSS Feed

3 Answers

  • Best Answer
    Sep 04, 2008 at 04:38 AM

    Hi.....

    Remove that primary key for the second field and assign your foregin key..table to that filed.....

    So when you give entries in that second filed it will be validated with its foregin key table......its nothing but check table...

    what all values in the foregin table only can given.....

    regards

    raja

    Add comment
    10|10000 characters needed characters exceeded

  • avatar image
    Former Member
    Sep 04, 2008 at 04:34 AM

    Hi,

    Goto se14 and Adjust & activate the table there....

    Regards

    Karthik D

    Add comment
    10|10000 characters needed characters exceeded

  • avatar image
    Former Member
    Sep 04, 2008 at 04:42 AM

    Hi,

    remove that PK field from the table,activate this table and again declare that field.

    In that way it will work.

    Regards,

    Amit

    Add comment
    10|10000 characters needed characters exceeded