Sign in to Community
Sign in to view all badges
I want to know how can we alter the size of the dafault autopk, there is something with custom autopk/pksequence, but I am unable to find How to make the autopk size - 3X of its default one?'
Autopk sequence goes by rdbms' capability and can be altered as needed, e.g. alter sequence ... maxvalue 99999.
Be mindful of the key's size, default autopk is 32 bit signed integer = ~2B max value.
Changing the field size by adding this attribute could work but sounds like something that would break warranty: