MCTS 70-433 Partition Functions and Partition Schemes

Step one - define you partition function

create partition function partition_function (int) as range right for values (10000,20000,30000);

Step two - build your partition scheme based on your partition function

create partition scheme partition_scheme 

  as partition partition_function to (part1, part2, part3, part4);

Step three - build table based on partition scheme 

create table employee (

  empID int,

  empName varchar(50)) on partition_scheme (empID)