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;