3

I'm not thinking of using it for the partition function. I just want to know, if it is supported or not.

Don't tell me why it is not a good idea to use such columns on partitioned tables.

4

Yes.

Read about it here (Simple Talk), section "Identities in a partitioned table"

  • He doesn't tell, what happens when there is a primary key on the identity column and partitions are swapped. – bernd_k Jul 27 '11 at 14:34
5

I would never tell you it is a not a good idea to use an IDENTITY column on a partitioned table.

Including an IDENTITY column in a partitioned table is supported.

Your Answer

By clicking “Post Your Answer”, you agree to our terms of service, privacy policy and cookie policy

Not the answer you're looking for? Browse other questions tagged or ask your own question.