Retro Eye care Haitian Deep Dark Default

DROP SHARDING KEY GENERATOR

Description

The DROP SHARDING KEY GENERATOR syntax is used to drop sharding key generators from the current database.

Syntax

DropShardingKeyGenerator ::=
  'DROP' 'SHARDING' 'KEY' 'GENERATOR' ifExists? keyGeneratorName (',' keyGeneratorName)*

ifExists ::=
  'IF' 'EXISTS'

keyGeneratorName ::=
  identifier

Supplement

  • ifExists clause is used to avoid Sharding key generator not exists error.

Example

  • Drop sharding key generator
DROP SHARDING KEY GENERATOR t_order_snowflake;
  • Drop multiple sharding key generators
DROP SHARDING KEY GENERATOR t_order_snowflake, t_item_snowflake;
  • Drop sharding key generator with ifExists clause
DROP SHARDING KEY GENERATOR IF EXISTS t_order_snowflake;

Reserved word

DROP, SHARDING, KEY, GENERATOR, IF, EXISTS