Foreign Key

Former Member — Wed, 10 Oct 2007 03:44:45 GMT

Hi Frnds,

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

Thanks,

Ruthra

Re: Foreign Key

Former Member — Wed, 10 Oct 2007 03:51:03 GMT

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

topic Foreign Key in Application Development and Automation Discussions

Foreign Key

Re: Foreign Key