Retro Eye care Haitian Deep Dark Default

DROP DEFAULT SHARDING STRATEGY

Description

The DROP DEFAULT SHARDING STRATEGY syntax is used to drop the default sharding strategy from the current database.

Syntax

DropDefaultShardingStrategy ::=
  'DROP' 'DEFAULT' 'SHARDING' ('TABLE' | 'DATABASE') 'STRATEGY' ifExists?

ifExists ::=
  'IF' 'EXISTS'

Supplement

  • ifExists clause is used to avoid Default sharding strategy not exists error.

Example

  • Drop default sharding table strategy
DROP DEFAULT SHARDING TABLE STRATEGY;
  • Drop default sharding database strategy
DROP DEFAULT SHARDING DATABASE STRATEGY;
  • Drop default sharding table strategy with ifExists clause
DROP DEFAULT SHARDING TABLE STRATEGY IF EXISTS;
  • Drop default sharding database strategy with ifExists clause
DROP DEFAULT SHARDING DATABASE STRATEGY IF EXISTS;

Reserved word

DROP, DEFAULT, SHARDING, TABLE, DATABASE, STRATEGY, IF, EXISTS