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

  1. CREATE PARTITION FUNCTION PF1(INT) AS RANGE LEFT FOR VALUES (1, 2, 3, 4)
  2. CREATE PARTITION SCHEME PS1 AS PARTITION PF1 ALL TO ([PRIMARY])
  3. 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

Related posts about database

Related posts about sql-server-2008