DROP DEFAULT SHADOW ALGORITHM

Description

The DROP DEFAULT SHADOW ALGORITHM syntax is used to drop the default shadow algorithm from the current database.

Syntax

DropDefaultShadowAlgorithm ::=
  'DROP' 'DEFAULT' 'SHADOW' 'ALGORITHM' ifExists?

ifExists ::=
  'IF' 'EXISTS'

Supplement

• ifExists clause is used to avoid Default shadow algorithm not exists error.

Example

• Drop default shadow algorithm

DROP DEFAULT SHADOW ALGORITHM;

• Drop default shadow algorithm with ifExists clause

DROP DEFAULT SHADOW ALGORITHM IF EXISTS;

Reserved word

DROP, DEFAULT, SHADOW, ALGORITHM, IF, EXISTS

Related links

• Reserved word