Retro Eye care Haitian Deep Dark Default

DROP SHARDING KEY GENERATE STRATEGY

DROP SHARDING KEY GENERATE STRATEGY

Description

The DROP SHARDING KEY GENERATE STRATEGY syntax is used to drop specified sharding key generate strategies in the currently selected database.

Syntax

DropShardingKeyGenerateStrategy ::=
  'DROP' 'SHARDING' 'KEY' 'GENERATE' 'STRATEGY' ifExists? keyGenerateStrategyName (',' keyGenerateStrategyName)*

ifExists ::=
  'IF' 'EXISTS'

keyGenerateStrategyName ::=
  identifier

Supplement

This syntax only removes sharding key generate strategy definitions, and does not cascade to remove the referenced sharding key generators;
ifExists clause is used to avoid Sharding key generate strategy not exists error.

Example

Drop sharding key generate strategy

DROP SHARDING KEY GENERATE STRATEGY order_id_strategy;

Drop multiple sharding key generate strategies at once

DROP SHARDING KEY GENERATE STRATEGY order_id_strategy, order_sequence_strategy;

Drop sharding key generate strategy with ifExists clause

DROP SHARDING KEY GENERATE STRATEGY IF EXISTS order_id_strategy;

Reserved word

DROP, SHARDING, KEY, GENERATE, STRATEGY, IF, EXISTS