DROP DEFAULT SHADOW ALGORITHM

Description

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

Syntax

Grammar Railroad diagram

DropDefaultShadowAlgorithm ::=
  'DROP' 'DEFAULT' 'SHADOW' 'ALGORITHM' 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 used for avoid Default shadow algorithm not exists error.

Example

• Drop default shadow algorithm for specified database

DROP DEFAULT SHADOW ALGORITHM FROM shadow_db;

• Drop default shadow algorithm for current database

DROP DEFAULT SHADOW ALGORITHM;

• Drop default shadow algorithm with ifExists clause

DROP DEFAULT SHADOW ALGORITHM IF EXISTS;

Reserved word

DROP, DEFAULT, SHODOW, ALGORITHM, FROM

Related links

• Reserved word