partitioning table @ sql server 2000

• muntasiriub

  SSCommitted

  Points: 1810

  More actions

  July 5, 2004 at 2:18 am

  #83085

  Can any one help me

  on partitioning table @ sql server 2000.

  I knew that oracle support partitioning table as follows:

   

  CREATE TABLE My_table

  (

   Id varchar(15) not null,

  …….

  SavingBalace   number(12,3) Default 0 not null

  …

  )

  partition by Ranage(Saving_Balance)

  (

   partition BR_Save_part1 Values Less Than (50000) Tablespace ts_cb_1,

    partition BR_Save_part2 Values Less Than (100000) Tablespace ts_cb_2,

   partition BR_Save_part3 Values Less Than (150000) Tablespace ts_cb_3,

   partition BR_Save_part4 Values Less Than (MAXVALUE) Tablespace ts_cb_5

  )

  Enable ROW MOVEMENT

  ;   

   

  Is it possible for sql server 2000?

   

  
  
  ..Better Than Before...

• dmartin

  Valued Member

  Points: 58

  More actions

  July 5, 2004 at 10:35 pm

  #513378

  I believe this functionality will be released in the next version of SQL Server.

• Hans Lindgren

  SSChampion

  Points: 10494

  More actions

  May 6, 2005 at 10:14 am

  #557403

  SQL Server 2000 does support partitioning, but not in the Oracle sense (yet).

  In SQL Server partitioning consists of one table for every partition, a check constraint (OBS be sure to NOT create the constraint with the NOCHECK option) that guarantees the partitioned data to be in the correct partition.

  'Over' these partitions you must create a UNION ALL view ex:

  CREATE VIEW myView AS

  SELECT Col1, Col2 FROM Part1

  UNION ALL

  SELECT Col1, Col2 FROM Part2

  UNION ALL

  SELECT Col1, Col2 FROM Part3

   

  Good luck, Hanslindgren!