Retro Eye care Haitian Deep Dark Default

DROP DEFAULT SHARDING STRATEGY

DROP DEFAULT SHARDING STRATEGY

Description

The DROP DEFAULT SHARDING STRATEGY syntax is used to drop default sharding strategy for specified database.

Syntax

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

ifExists ::=
  'IF' 'EXISTS'

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 Default sharding strategy not exists error.

Example

Drop default sharding table strategy for specified database

DROP DEFAULT SHARDING TABLE STRATEGY FROM sharding_db;

Drop default sharding database strategy for current database

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, FROM

Reserved word