Altering a database partition group

Use the ALTER DATABASE PARTITION GROUP statement to add, or drop, database partitions in a database partition group. After adding or dropping database partitions, use the REDISTRIBUTE DATABASE PARTITION GROUP command to redistribute the current data across the new set of database partitions in the database partition group.