Partition Column List Dialog Box

If a table has an associated partition scheme, you can use this dialog box to choose which column(s) the partition function is applied to. For the function to work, the data type of the column you switch to must be the same as the data type of the column defined in the partition function.

For more information on partition schemes and functions see SQL Server Books Online.

Note

Your computer might show different names or locations for some of the Visual Studio user interface elements in the following instructions. The Visual Studio edition that you have and the settings that you use determine these elements. For more information, see Visual Studio Settings.

  • Data Type
    Shows the data types of the columns defined in the partition scheme.

  • Column
    Provides a drop-down list where you can choose the column to apply the partition function to.

See Also

Reference

Table Properties