Removing a partitioning scheme from a table with one filegroup and no clustered indexes

• jasona.work

  SSC Guru

  Points: 50082

  More actions

  May 2, 2013 at 9:55 am

  #273543

  OK, I'm going to be removing a partitioning scheme from a table which no longer needs it, and just want to confirm a few things.

  First, the table lives entirely on a single filegroup, the Primary filegroup. There is only one index, a non-clustered, which is using the partitioning scheme.

  So, if my reading is correct, I should be able to re-create the index on Primary, then drop the partition scheme and function, yes?

  I'm basing this on this AskSQLServerCentral post and this blog post.

  Thanks,

  Jason