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