database partition

Hello,
My question is about database partition. I know how to define a filegroup,
Partition Function, Partition scheme and do a partion on brand new table.
But my question is how can I partition a existing table without droping it!!
Thanks for help
Hooman"Microsoft" <Hooman@.ebatts.com> wrote in message
news:uP7HJXatGHA.1216@.TK2MSFTNGP03.phx.gbl...
> Hello,
> My question is about database partition. I know how to define a
> filegroup,
> Partition Function, Partition scheme and do a partion on brand new table.
> But my question is how can I partition a existing table without droping
> it!!
>
You move it to the partions scheme, just like you would move it to a
different filegroup.
Something Like
create unique clustered index pk_MyTable
on MyTable(id) with drop_existing
on MyPartitionScheme(id)
David

database partition

Hello,
My question is about database partition. I know how to define a filegroup,
Partition Function, Partition scheme and do a partion on brand new table.
But my question is how can I partition a existing table without droping it!!
Thanks for help
Hooman"Microsoft" <Hooman@.ebatts.com> wrote in message
news:uP7HJXatGHA.1216@.TK2MSFTNGP03.phx.gbl...
> Hello,
> My question is about database partition. I know how to define a
> filegroup,
> Partition Function, Partition scheme and do a partion on brand new table.
> But my question is how can I partition a existing table without droping
> it!!
>
You move it to the partions scheme, just like you would move it to a
different filegroup.
Something Like
create unique clustered index pk_MyTable
on MyTable(id) with drop_existing
on MyPartitionScheme(id)
David