Retro Eye care Haitian Deep Dark Default

ShardingSphere > Reference > DistSQL > Syntax > RDL Syntax > Rule Definition > Shadow > DROP DEFAULT SHADOW ALGORITHM

DROP DEFAULT SHADOW ALGORITHM

Description

The DROP DEFAULT SHADOW ALGORITHM syntax is used to drop default shadow algorithm for specified database

Syntax

DropDefaultShadowAlgorithm ::=
  'DROP' 'DEFAULT' 'SHADOW' 'ALGORITHM' ('FROM' databaseName)?

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 default shadow algorithm for specified database

DROP DEFAULT SHADOW ALGORITHM FROM test1;

Drop default shadow algorithm for current database

DROP DEFAULT SHADOW ALGORITHM;

Reserved word

DROP, DEFAULT, SHODOW, ALGORITHM, FROM

Reserved word