Can I use partition relation tables?

Asked Aug 29 '12 at 04:30

Active Aug 30 '12 at 03:16

Viewed 137 times

Currently, I have one Table A (parent) with primary key as 'KeyID'. This table has 2 children-tables B and C. In table B, it has foreign key 'KeyID'. Same for table C. Below is schema for 3 tables:

tblA (KeyID, POName, DateReceiver, Desc)
tblB (subkeyID, KeyID, ItemName, Desc)
tblC (subkey2ID, KeyID, ShipName, Desc)

The relationships are one-to-many

So, with the relationship among these tables:

Can we use 'partition table' feature in MS SQL Server 2008 for these 3 tables?
If I partition tblA for Column DateReceiver, how can I partition for 2 tables tblB and tblC? which column at tblB and tblC will be used?

Please advice.

Thank you very much.

edited Aug 30 '12 at 03:16

asked Aug 29 '12 at 04:30

Thang Lang

here which table you want to partition? – AnandPhadke Aug 29 '12 at 05:15
What is the motivation for partitioning? – Tim Harkin Aug 29 '12 at 11:54
Are the relationships many-to-one (B -> A and C -> A) or one-to-one? – bluevector Aug 29 '12 at 21:12
is there anyone knows about this? please help me. Thanks. – Thang Lang Aug 31 '12 at 02:47

Can I use partition relation tables?

0 Answers0