Total Pageviews

Existence of partition function for given value

SELECT ‘partition function exist for given value’
FROM sys.partition_functions  fn
INNER JOIN sys.partition_range_values val
ON fn.function_id = val.function_id
WHERE fn.name = '<partition function name>'
AND val.value = '<value>'

No comments:

Post a Comment