SQL Server Partitioning

• Thinky Night

  SSCommitted

  Points: 1663

  More actions

  August 1, 2011 at 2:22 am

  #241550

  I have two tables:

  CREATE TABLE T1(

  ID,

  NAME,

  CREATE_TIME

  ) ON PRIMARY

  CREATE TABLE T2(

  ID,

  T1_ID

  NAME

  ) ON PRIMARY

  FOREIGN KEY -----> T1.ID = T2.T1_ID

  How do i partition table t2 by T1.CREATE_TIME?

  Regards,

• Vishal.Gajjar

  SSCrazy

  Points: 2285

  More actions

  August 1, 2011 at 3:13 am

  #1361409

  Hi,

  AFAIK, this is not possible.

  The partition key - the column used for partitioning must exist as a single column in the same table.

  Vishal Gajjar
  http://SqlAndMe.com