ALTER TABLE

Drop clustered constraint clause:

drop_clustered_constraint_option:
    { 
        MAXDOP = max_degree_of_parallelism
      | ONLINE = {ON | OFF }
      | MOVE TO { partition_scheme ( column ) | filegroup
          | "default"}
    }

Examples

ALTER TABLE MyTable ALTER COLUMN MyOLDColumn DROP WITH MAXDOP=2;

"At a good table we may go to school" - Thomas Fuller

Related commands

CREATE TABLE
DROP TABLE