Truncate or switch range of a partitioned table

• Federico Iori

  SSCommitted

  Points: 1625

  More actions

  December 19, 2012 at 3:53 pm

  #393817

  Comments posted to this topic are about the item Truncate or switch range of a partitioned table

• Arul R

  SSCommitted

  Points: 1565

  More actions

  January 9, 2013 at 11:46 pm

  #1575605

  Hi Friend,

  I need to know about the below table,

  view_all_partitions_trg_prod

  .

  Can u Pls explain.

  Thanks

  Arul R

• Federico Iori

  SSCommitted

  Points: 1625

  More actions

  January 10, 2013 at 1:46 am

  #1575643

  Arul R (1/9/2013)

  ---

  Hi Friend,

  I need to know about the below table,

  view_all_partitions_trg_prod

  .

  Can u Pls explain.

  Thanks

  Arul R

  In the article is written :

  This script requires the creation of the big view in

  http://www.sqlservercentral.com/scripts/Partitioning/73324/

  The view is view_all_partitions_trg_prod , please read it

• Arul R

  SSCommitted

  Points: 1565

  More actions

  January 10, 2013 at 2:39 am

  #1575664

  The View is for which table, where is the query for that view

  in the stored procedure.

• Federico Iori

  SSCommitted

  Points: 1625

  More actions

  January 10, 2013 at 2:56 am

  #1575671

  Arul R (1/10/2013)

  ---

  The View is for which table, where is the query for that view

  in the stored procedure.

  The DDL for the view is at : http://www.sqlservercentral.com/scripts/Partitioning/73324/

  The view display information for all tables in the current database

• akljfhnlaflkj

  SSC Guru

  Points: 76202

  More actions

  May 2, 2016 at 12:50 pm

  #1875990

  Thanks for the script.