DROP PARTITION POLICY [IF EXISTS] partition_policy_name
Parameter | Required | Description |
partition_policy_name | Required | Name of the partition affinity policy. |
# Delete the existing partition affinity policy named pp1.tdsql [(none)]> drop partition policy pp1;Query OK, 0 rows affected (0.01 sec)# Delete the non-existent partition affinity policy.tdsql [(none)]> drop partition policy pp1;ERROR 8596 (HY000): Unknown partition policy 'pp1'.# Specify IF EXISTS to delete a non-existent partition affinity policy.tdsql [(none)]> drop partition policy if exists pp1;Query OK, 0 rows affected, 1 warning (0.00 sec)
Was this page helpful?
You can also Contact sales or Submit a Ticket for help.
Help us improve! Rate your documentation experience in 5 mins.
Feedback