Trigger Foreigh Key change when changing size of Primary key
Hello,
Please help me with this situation.
Let's say I have a table with a PK and several other tables having FK pointing to PK.
PK is of type number(3) and FK are of type number(3).
The issue appears when I have to modify my PK e.g. from number(3) column type to number(5), but this does not trigger a modification of FK from number(3) to number(5) leading to insert problems.
The modification is done manually, but this is hard in a large database.
Is there any way to trigger this automatically or a script to do alter FK for all keys referencing my PK?
Please help me with this situation.
Let's say I have a table with a PK and several other tables having FK pointing to PK.
PK is of type number(3) and FK are of type number(3).
The issue appears when I have to modify my PK e.g. from number(3) column type to number(5), but this does not trigger a modification of FK from number(3) to number(5) leading to insert problems.
The modification is done manually, but this is hard in a large database.
Is there any way to trigger this automatically or a script to do alter FK for all keys referencing my PK?
0