Click here to monitor SSC
SQLServerCentral is supported by Redgate
Log in  ::  Register  ::  Not logged in
Home       Members    Calendar    Who's On

Add to briefcase

Removing a partitioning scheme from a table with one filegroup and no clustered indexes Expand / Collapse
Posted Thursday, May 2, 2013 9:55 AM



Group: General Forum Members
Last Login: Thursday, December 1, 2016 2:17 PM
Points: 1,772, Visits: 10,711
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.

Post #1448877
« Prev Topic | Next Topic »

Add to briefcase

Permissions Expand / Collapse