Click here to monitor SSC
SQLServerCentral is supported by Red Gate Software Ltd.
 
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
Author
Message
Posted Thursday, May 2, 2013 9:55 AM


SSC Eights!

SSC Eights!SSC Eights!SSC Eights!SSC Eights!SSC Eights!SSC Eights!SSC Eights!SSC Eights!

Group: General Forum Members
Last Login: Today @ 10:46 AM
Points: 987, Visits: 5,167
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
Post #1448877
« Prev Topic | Next Topic »

Add to briefcase

Permissions Expand / Collapse