Retro Eye care Haitian Deep Dark Default

DROP SHARDING KEY GENERATOR

Description

The DROP SHARDING KEY GENERATOR syntax is used to drop sharding key generator for specified database.

Syntax

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

ifExists ::=
  'IF' 'EXISTS'

keyGeneratorName ::=
  identifier

databaseName ::=
  identifier

Supplement

  • When databaseName is not specified, the default is the currently used DATABASE. If DATABASE is not used, No database selected will be prompted;
  • ifExists clause is used for avoid Sharding key generator not exists error.

Example

  • Drop sharding key generator for specified database
DROP SHARDING KEY GENERATOR t_order_snowflake FROM sharding_db;
  • Drop sharding key generator for current database
DROP SHARDING KEY GENERATOR t_order_snowflake;
  • Drop sharding key generator with ifExists clause
DROP SHARDING KEY GENERATOR IF EXISTS t_order_snowflake;

Reserved word

DROP, SHARDING, KEY, GENERATOR, FROM