Creation of a partitioning function

The partition function defines the boundaries between each partition. The ImageMaster partition keys are of type VARCHAR(50), so this partition function takes such a parameter and defines ranges for the desired number of partitions. The values contained in the partition key are defined by the ImageMaster partitioning configuration.

This step can only be performed via a SQL script using the CREATE PARTITION FUNCTION statement. After creation, this object can be viewed in Microsoft SQL Server Management Studio under the Storage node for the database.