Previous Topic: Define SQL Server Full-Text CatalogsNext Topic: Define a Partition for a SQL Server Table


SQL Server Partitions

Support for partition objects is provided in erwin® Data Modeler for SQL Server 2008, 2012, 2014, and 2016

Partitioning is the process of creating smaller tables containing a subset of the data with the same format as the original table. Each partitioned table has rows allocated to it based on some characteristic of the data, such as specific key ranges. Partitioning can improve application processing speeds and reduce the potential for conflicts in multi-site update replication.

SQL Server Table Editor

Define a partition for a table using the Partitions tab.

SQL Server Table Index Editor

Define a partition for a table index using the Partitions tab.

SQL Server View Index Editor

Define a partition for a view index using the Partitions tab.

SQL Server Partition Function Editor

Specify a function that defines how the rows of a partitioned table or index are spread across a set of partitions based on the values of specific columns, which are referred to as partitioning columns.

SQL Server Partition Scheme Editor

Specify a database object (scheme) that maps the partitions of a partition function to a set of filegroups.

More information:

Define SQL Server Partition Functions

Define SQL Server Partition Schemes