.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"}'