question

anuk avatar image
anuk asked

Get unique partition number to the table partitions on the same column in a database

I created partitions on two tables on the same partition id column. But the sql server is assigning the same partition number to the partitions where I have same partition id column. I want partition numbers to be unique. Is there any way to achieve this????
partitioningpartitiontable partition
10 |1200

Up to 2 attachments (including images) can be used with a maximum of 512.0 KiB each and 1.0 MiB total.

1 Answer

·
Tom Staab avatar image
Tom Staab answered
The partition number is a 1-based counter of partitions within the owning index (or table heap if there is no clustered index). You cannot change it.
10 |1200

Up to 2 attachments (including images) can be used with a maximum of 512.0 KiB each and 1.0 MiB total.

Write an Answer

Hint: Notify or tag a user in this post by typing @username.

Up to 2 attachments (including images) can be used with a maximum of 512.0 KiB each and 1.0 MiB total.