Undo Table Partitioning - SQL Server 2008
Posted
by Binder
on Stack Overflow
See other posts from Stack Overflow
or by Binder
Published on 2010-06-03T13:00:09Z
Indexed on
2010/06/03
13:04 UTC
Read the original article
Hit count: 727
I have a table 'X' and did the following
- CREATE PARTITION FUNCTION PF1(INT) AS RANGE LEFT FOR VALUES (1, 2, 3, 4)
- CREATE PARTITION SCHEME PS1 AS PARTITION PF1 ALL TO ([PRIMARY])
- CREATE CLUSTERED INDEX CIDX_X ON X(col1) ON PS1(col1)
this 3 steps created 4 logical partitions of the data I had.
My question is, how do i revert this partitioning to its original state ?
© Stack Overflow or respective owner