Logo Questions Linux Laravel Mysql Ubuntu Git Menu
 

Partitioning Existing Tables

How do I partition existing table in SQL Server 2005/08? I couldn't find a better clue on it.

like image 212
Aneef Avatar asked Jan 25 '10 12:01

Aneef


1 Answers

Here is a full article on how to do this. (Create table, insert data, then partition)

Trick is to move the table to the new partition.

DROP INDEX MyTable_IXC ON MyTable WITH (Move To [Data Partition Scheme] (ID) )
like image 178
Binoj Antony Avatar answered Oct 17 '22 21:10

Binoj Antony