How to move clustered index from one filegroup to another filegroup.

Question

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

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

DinoRS SSCrazy Points: 2683 More actions · Answer 1

Hi,
use the CREATE INDEX idx Statement with the (DROP_EXISTING= ON) Option.

You should be aware that moving a Clustered Index from one FG to another will also move the entire Table to the new FG.