patternMinor
Is it possible with SQL Server 2008 to have a Partioned Tables with an Identity Column?
Viewed 0 times
tablespartionedidentity2008columnwithsqlpossibleserverhave
Problem
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.
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.
Solution
Yes.
Read about it here (Simple Talk), section "Identities in a partitioned table"
Read about it here (Simple Talk), section "Identities in a partitioned table"
Context
StackExchange Database Administrators Q#4141, answer score: 4
Revisions (0)
No revisions yet.