Skip to Content
author's profile photo Former Member
Former Member

Deleting Primary Key fields

Can we delete Primary Key fields of a transparent table which is already having the data in Production Server?

If Yes, could you help me out with the procedure

Add a comment
10|10000 characters needed characters exceeded

Assigned Tags

Related questions

6 Answers

  • Best Answer
    author's profile photo Former Member
    Former Member
    Posted on Oct 04, 2012 at 02:24 PM

    You can not do it in Production directly, rather u need to do in development server and transport , transport request to production.

    once transport request is in production, run SE14 to adjust the database table.

    Add a comment
    10|10000 characters needed characters exceeded

  • Posted on Oct 10, 2012 at 06:20 AM

    Hi,

    Yes you can delete pk's but one pk is mandatory and after deleting the pk u can adjust the table in tcode : SE14 without lose of data/records.

    Regards

    Mahesh

    Add a comment
    10|10000 characters needed characters exceeded

  • author's profile photo Former Member
    Former Member
    Posted on Oct 10, 2012 at 11:36 AM

    Hi,

    Yes you can delete the primary key of a transparent table but you should not do it in production server

    because once you delete the primary key field, system will ask you to activate and adjust the table again, you can do it through SE14 tcode by selecting activate and adjuct option, but there are chnces

    of table data might be deleted.

    Regards

    Pankaj

    Add a comment
    10|10000 characters needed characters exceeded

  • Posted on Oct 04, 2012 at 02:32 PM

    Deleting primary key fields will most likely lead to duplicate keys, so you will lose data when adjusting the table as suggested above.

    Make sure you know what you are doing, search for additional information and documentation.

    Thomas

    Add a comment
    10|10000 characters needed characters exceeded

  • author's profile photo Former Member
    Former Member
    Posted on Jan 08, 2013 at 10:38 AM

    Hi Kalyan,

    The Primary key field can be removed , also the primary key field can be deleted irrespective of the table being present in Production / Dev server.

    Since, the transparent table is present in Production, it can be risky do make any major changes without proper approvals.

    Please make sure to make adjustments in Table definition from Database Utility.

    Utilities - > Database Object -> Database Utility

    Regards

    Vivek Batta

    Add a comment
    10|10000 characters needed characters exceeded

  • author's profile photo Former Member
    Former Member
    Posted on Jan 09, 2013 at 01:29 PM

    you cannot delete primary key fields of table which have data. create another table in dev, and move to production and copy data...and then delete table. Note: table name should update all objects which have used this table.

    Add a comment
    10|10000 characters needed characters exceeded

Before answering

You should only submit an answer when you are proposing a solution to the poster's problem. If you want the poster to clarify the question or provide more information, please leave a comment instead, requesting additional details. When answering, please include specifics, such as step-by-step instructions, context for the solution, and links to useful resources. Also, please make sure that you answer complies with our Rules of Engagement.
You must be Logged in to submit an answer.

Up to 10 attachments (including images) can be used with a maximum of 1.0 MB each and 10.5 MB total.