Is it possible with SQL Server 2008 to have a Partioned Tables with an Identity Column?

Question

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.

gbn · Accepted Answer · 2011-07-27 06:09:46Z

up vote 3 down vote accepted

Yes.

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

answered Jul 27 '11 at 6:09

gbn
42k351104

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

Robert Miller · Answer 2 · 2011-07-27 06:04:20Z

up vote 4 down vote

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.

answered Jul 27 '11 at 6:04

Robert Miller
67626

2 Answers