ALTER PARTITION SCHEME

Hi

How do I alter the PARTITION SCHEME to include a new range?

I can alter the PARTITION FUNCTION but how do I alter the PARTITION SCHEME to include the new range I added in the PARTITION FUNCTION ?

/Many thanks

Hi,

Why do you need to specify a new range in ALTER PARTITION SCHEME?

As you have already specified the new range in ALTER PARTITION FUNCTION. Now you only need to specify the NEXT USED filegroup.

Ravi.

|||

Well mabye not.

I dynamically create a new file and filegroup each new month; shall I not also alter the schema to reflect this?

Thanks