qua_get_partitioning_schema

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;

See also#