Post reply

Table partition - changing column

  • December 27, 2017 at 12:42 pm

    #327008

    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

  • December 27, 2017 at 5:31 pm

    #1973649

    as1981 - Wednesday, December 27, 2017 12:42 PM

    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

  • December 28, 2017 at 2:19 am

    #1973682

    Thank you

Viewing 3 posts - 1 through 2 (of 2 total)

You must be logged in to reply to this topic. Login to reply