Drop index .......with (Move To [Data Partition Scheme] (.....))

Question

I hope there is only one method to create partition on nonempty table (pls share any there is any other method for same) :

Drop index .......with (Move To [Data Partition Scheme] (.....))

Does this commond drop the actual index? if yes, can i create similar index on the table?

Answer 1

0

That command doesn't create a partition - it would remove any partitions created by the index being dropped. To create a partition (or, more accurately, an index over a series of partitons) you would use CREATE INDEX and specify a partition scheme as the destination data space:

CREATE INDEX [myPartitionedIndex]
ON [myTable] ([column])
ON [myPartitionScheme] ([partitoning_column])

In answer to your other questions, yes - the index is actually dropped and yes, you can then create a similar index.

answered Feb 22 '10 at 08:05 AM

Matt Whitfield ♦♦
29.2k ● 56 ● 63 ● 87

Thanks Matt,

what is a difference between
CREATE TABLE......on [myPartitionScheme] ([partitoning_column] and CREATE INDEX......on [myPartitionScheme] ([partitoning_column] ? Which one is preferred & why?

Feb 22 '10 at 10:01 AM kardile

When you specify ON in CREATE TABLE, it's either specifying where the heap goes (if you don't specify a clustered constraint) or it's actually doing nothing at all (if you do specify a clustered constraint). When you specify it on create index, you're specifying where that index will be stored, whether clustered or not.

Feb 22 '10 at 10:46 AM Matt Whitfield ♦♦

(comments are locked)

Drop index .......with (Move To [Data Partition Scheme] (.....))

Follow this question

Related Questions