How can I rebuild my clustered index and change its filegroup, but don't wan
t
to use the drop existing clause, which will drop and recreate all my
non-clustered indexes of that table ?
Thanks,
RangaTry:
CREATE CLUSTERED INDEX IX_MyTable on MyTable (MyCol) WITH DROP_EXISTING ON
[MyFileGroup]
It will not drop and recreated the nonclustered indexes.
Tom
----
Thomas A. Moreau, BSc, PhD, MCSE, MCDBA, MCITP, MCTS
SQL Server MVP
Toronto, ON Canada
.
"Ranga" <Ranga@.discussions.microsoft.com> wrote in message
news:20A15DB9-FEF8-426A-A2E2-8B2C69633E9F@.microsoft.com...
How can I rebuild my clustered index and change its filegroup, but don't
want
to use the drop existing clause, which will drop and recreate all my
non-clustered indexes of that table ?
Thanks,
Ranga
Subscribe to:
Post Comments (Atom)
No comments:
Post a Comment