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' keyGeneratorName ('FROM' databaseName)?

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.

Example

  • Drop sharding key generator for specified database.
DROP SHARDING KEY GENERATOR t_order_snowflake FROM test1;
  • Drop sharding key generator for current database.
DROP SHARDING KEY GENERATOR t_order_snowflake;

Reserved word

DROP, SHARDING, KEY, GENERATOR, FROM