I have a table that has been partitioned recently based on a datetime column. The same table had a primary key (clustered) on the ID column. During the partitioning of the table, the primary key is dropped. Again after the partitioning when I tried creating the primary key (clustered) again, It created without any errors. But to my surprise when I checked the table the partition was removed. Thus on doing more research on this, I found that when we create a new clustered index on a partitioned table the partition goes off.
Can anyone please help me out in creating a clustered primary key on the partitioned table, since non clustered primary key is degrading the performance.