Once a surrogate key is generated on an out row for a column, is this keeps on increasing even if we delete all data and reload.
Is there any way if we can generate from starting number after deleting all data from target table?
thanks,
tom
Surrogate Key generation
Moderators: chulett, rschirm, roy
-
- Participant
- Posts: 54607
- Joined: Wed Oct 23, 2002 10:52 pm
- Location: Sydney, Australia
- Contact:
How, exactly, are you generating the value? The mechanism for resetting the sequence will differ depending on your answer.
Of course, if it's a surrogate key the actual value is irrelevant; all a surrogate key provides is uniqueness.
Of course, if it's a surrogate key the actual value is irrelevant; all a surrogate key provides is uniqueness.
IBM Software Services Group
Any contribution to this forum is my own opinion and does not necessarily reflect any position that IBM may hold.
Any contribution to this forum is my own opinion and does not necessarily reflect any position that IBM may hold.
How can this be done
How to reset SK value?
thanks,
Tom
thanks,
Tom
Still Doubt
I am generating using KeyMgtGetNextValue(%Sequence Name%).
So if I delete all rows in target table, and run with source data. How to reset SK ID to start from id=1.
thanks,
Tom
So if I delete all rows in target table, and run with source data. How to reset SK ID to start from id=1.
thanks,
Tom