qua_get_partitioning_schema

Retrieves partitioning schema for a given view.

Arguments

  • @view_name - a fully qualified name of view which partitioning mode will be returned.
  • @schema - OUTPUT NVARCHAR(MAX) that will contain JSON string describing details of partitioning configuration.

Example

Gets partitioning schema for ‘AdventureWorksDW2012_spark.dbo.DimEmployee.

DECLARE @schema NVARCHAR(MAX);

EXEC qua_get_partitioning_schema
    @view_name = 'AdventureWorksDW2012_spark.dbo.DimEmployee'
  , @schema = @schema OUTPUT;

SELECT @schema;