What is the use of switch operator used in partitioning the data

• happysmile

  SSC Veteran

  Points: 253

  More actions

  June 6, 2011 at 7:36 pm

  #239376

  Hi,

  What is the use of switch operator used in partitioning the data in Sql Server 2008?

  I tried to google it but unfortunately I didnt find any detailed answers to it.

  Thanks in advance.

• Suresh B.

  SSC-Insane

  Points: 22986

  More actions

  June 6, 2011 at 10:23 pm

  #1334777

  BOL:

  You can use the Transact-SQL ALTER TABLE...SWITCH statement to quickly and efficiently transfer subsets of your data in the following ways:

  Assigning a table as a partition to an already existing partitioned table.

  Switching a partition from one partitioned table to another.

  Reassigning a partition to form a single table.