Database Administrators Stack Exchange is a question and answer site for database professionals who wish to improve their database skills and learn from others in the community. Join them; it only takes a minute:

Sign up
Here's how it works:
  1. Anybody can ask a question
  2. Anybody can answer
  3. The best answers are voted up and rise to the top

Oracle 11g has introduced a new feature that is called Reference Partition.

Using reference partitioning, a child table can inherit the partitioning characteristics from a parent table.

Is there an equivalent feature in SQL Server?

share|improve this question
up vote 3 down vote accepted

Not exactly.

In SQL Server, you create a partition function and a partition scheme, which are objects separate from the tables themselves, which define the partitioning characteristics. Then, tables are created referencing the partition scheme.

So, yes, there is a central definition of the partitioning characteristics, but the reference is made to the partition scheme (which could be anything), not to any particular table or relationship.

share|improve this answer
Note that table and index partitioning is only available in the Enterprise Edition of SQL Server (and thus also in the Developer and Enterprise Evaluation editions). References: SQL Server 2008, SQL Server 2012. – Greenstone Walker Jun 7 '13 at 2:21

Your Answer


By posting your answer, you agree to the privacy policy and terms of service.

Not the answer you're looking for? Browse other questions tagged or ask your own question.