Retro Eye care Haitian Deep Dark Default

DROP SHARDING KEY GENERATOR

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

Reserved word