Partition Functions

Question

I am creating scripts that will create partitioned tables.  I would like to include an IF NOT EXISTS wrapper around my code.

How can I determine if a partition function already exsists, for example:

     IF NOT EXISTS (SELECT * FROM INFORMATION_SCHEMA.ROUTINES WHERE ROUTINE_NAME = 'MyPartitionFnName'
           CREATE PARTITION FUNCTION MyPartitionFnName (datetime)....

I would also like to do the same thing for the SCHEME:

     IF NOT EXISTS (SELECT * FROM sys.scheme WHERE schemeName = 'MySchemeName')
           CREATE PARTITION SCHEME MySchemeName


Can this be done?

Thanks in advance.

Answer 1

I found the answer, I wonder if I can mark my own answer as being the solution?!

IF

 

NOT EXISTS (SELECT * FROM [sys].[partition_functions] WHERE [name] = 'MyPartitionFnName')

IF

 

NOT EXISTS (SELECT * FROM [sys].[partition_schemes] WHERE [name] = 'MyPartitionSchemeName')

 

 

Answer 2

lol, guess so.  I'd like to thank myself for all the help.