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?

1 Answer 1


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.

  • 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. Commented Jun 7, 2013 at 2:21

Your Answer

By clicking “Post Your Answer”, you agree to our terms of service and acknowledge you have read our privacy policy.

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