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

Related links

• Reserved word
• SHOW SHARDING KEY GENERATE STRATEGY