All,
According to the Microsoft documentation you can effectively remove the partition from a table by changing it to just one partition.
If I understand correctly then that means I couldn't change the partition column because it's still a partitioned table?
To partition on a new column I would have to create an empty, identical table, copy the data across and rename the table?
This is based on 2016 Standard SP1.
Thanks
Here are a couple of methods to remove partitioning with examples for both:
How to Remove (Undo) Table Partitioning
Sue