How to unpartition a table (try 2) ?

Question

Viewing 2 posts - 1 through 1 (of 1 total)

You must be logged in to reply to this topic. Login to reply

Pavle-192195 SSChasing Mays Points: 652 More actions · Answer 1

I found a workaround if we are partitioning on a clustered index which is a not the PK (i don't remember it working with the PK)

create clustered index IX_P_Tab_col on Tab(col)

with (drop_existing = on)

on [primary]

Note: simply dropping the clustered index doesn't move the table, you need to recreate it on the target FG for the table to move...