title: Undo Table Partitioning
body: <p>I have a table 'X' and did the following</p>
  
  <ol>
  <li>CREATE PARTITION FUNCTION PF1(INT) AS RANGE LEFT FOR VALUES (1, 2, 3, 4)</li>
  <li>CREATE PARTITION SCHEME PS1 AS PARTITION PF1 ALL TO ([PRIMARY])</li>
  <li>CREATE CLUSTERED INDEX CIDX_X ON X(col1) ON PS1(col1)</li>
  </ol>
  
  <p>this 3 steps created 4 logical partitions of the data I had.</p>
  
  <p>My question is, how do I revert this partitioning to its original state ?</p>