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.
Add a comment
|
2 Answers
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_kCommented Jul 27, 2011 at 14:34
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.
