Creating Models › Target Servers for Physical Models › Database Property Editors › SQL Server Common Functionality › SQL Server Partitions › Define a Partition for a SQL Server Table

Define a Partition for a SQL Server Table

Use the SQL Server Table Editor to define a partition for a table in either a SQL Server 2005 or 2008 physical model. You need a column on which to partition the table, a scheme to determine where the partition resides, and a partition function to define the boundary of the partition.

To define a SQL Server table partition

1. Click Tables on the Model menu.

   The SQL Server Table Editor opens.

2. Select the table in the Navigation Grid for which you want to define a partition.

   Note: Use the Enter filter text box to filter a very large list of tables to quickly locate the one for which you want to define a partition.

3. Click the Partitions tab and work with the following options:

   Partition Columns

   Specifies the columns upon which to partition the table. Select the check box to specify each column.

   Scheme

   Specifies the scheme that defines the partition boundaries and the file groups in which the partition resides. The Scheme '<table_name>' Filegroups field displays the scheme's partition boundary and the list of file groups to store the partitions.

4. Click Close.

   The partition is defined and the SQL Server Table Editor closes.