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: 

Foreign Key

Go to solution
Former Member

‎10-10-2007 4:44 AM

0 Kudos

Hi Frnds,

Is it possible to overwrite Foreign Key. If so, pls give me the procedure.

Thanks,

Ruthra

1 ACCEPTED SOLUTION

Go to solution
former_member223537
Active Contributor

‎10-10-2007 4:51 AM

0 Kudos

Hi,

Modifying Foreign Key is possible. But if there is an already existing data in the table & if you are trying to modify foreign keys, then it would be difficult.

You need to take following points into account before modifying :

1. How many tables would be impacted

2. Whether data exists in those tables.

3. If data exists, then what would be the impact after modifying foreign keys

4. Will you be able to fix the issues of data once foreign keys are modified

5. Is it really necessary to modify foreign key.

6. Is there any other alternative which will have less impact

Best regards,

Prashant

1 REPLY 1

Go to solution
former_member223537
Active Contributor

‎10-10-2007 4:51 AM

0 Kudos

Hi,

Modifying Foreign Key is possible. But if there is an already existing data in the table & if you are trying to modify foreign keys, then it would be difficult.

You need to take following points into account before modifying :

1. How many tables would be impacted

2. Whether data exists in those tables.

3. If data exists, then what would be the impact after modifying foreign keys

4. Will you be able to fix the issues of data once foreign keys are modified

5. Is it really necessary to modify foreign key.

6. Is there any other alternative which will have less impact

Best regards,

Prashant