Your achievements

Level 1

0% to

Level 2

Tip /
Sign in

Sign in to Community

to gain points, level up, and earn exciting badges like the new
BedrockMission!

Learn More

View all

Sign in to view all badges

Altering the size of autopk sequence by 3X default size

Avatar

Avatar
Level 1
SKomal76
Level 1

Likes

0 likes

Total Posts

3 posts

Correct Reply

0 solutions
View profile

Avatar
Level 1
SKomal76
Level 1

Likes

0 likes

Total Posts

3 posts

Correct Reply

0 solutions
View profile
SKomal76
Level 1

09-05-2021

Hello,

 

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?'

 

Thanks.

Komal

View Entire Topic

Avatar

Avatar
Establish
MVP
wodnicki
MVP

Likes

958 likes

Total Posts

1,079 posts

Correct Reply

506 solutions
Top badges earned
Establish
Affirm 500
Contributor
Shape 1
Give Back 100
View profile

Avatar
Establish
MVP
wodnicki
MVP

Likes

958 likes

Total Posts

1,079 posts

Correct Reply

506 solutions
Top badges earned
Establish
Affirm 500
Contributor
Shape 1
Give Back 100
View profile
wodnicki
MVP

09-05-2021

Hi,

 

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:

  • <attribute name="id" type="int64"/>

 

Thanks,

-Jon