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

Related links

• Reserved word