.alter-merge table partitioning policy

Alters a table partitioning policy. The partitioning policy defines if and how extents (data shards) should be partitioned for a specific table or a materialized view. The command requires DatabaseAdmin permissions.

Syntax

.alter-merge table TableName policy partitioning PolicyObject

Arguments

TableName - Specify the name of the table. PolicyObject - Define a policy object, see also partitioning policy.

Example

Delete the policy at the table level:

.alter-merge table MyTable policy partitioning '{"EffectiveDateTime":"2023-01-01"}'