A partition scheme in database is that maps the partitions of a partitioned table or index to filegroups. The number and domain of the partitions of a partitioned table or index are determined in a partition function. A partition function must first be created in a CREATE PARTITION FUNCTION statement before partition scheme.
Permission can be used to used to create partition scheme:-
- ALTER ANY DATASPACE permission. This permission defaults to members of the sysadmin fixed server role and the db_owner and db_ddladmin fixed database roles.
- CONTROL or ALTER permission on the database in which partition scheme is being created.
- CONTROL SERVER or ALTER ANY DATABASE permission on the server of the database in which partition scheme is being created.
create partition scheme ps as partition pf to (a,b,c,d,e,f,g)
PF stands here for the partition function you earlier created.