ALTER DEFAULT SHADOW ALGORITHM

Description

The ALTER DEFAULT SHADOW ALGORITHM syntax is used to alter a default shadow algorithm.

Syntax

Grammar Railroad diagram

  1. AlterDefaultShadowAlgorithm ::=
  2.   'ALTER' 'DEFAULT' 'SHADOW' 'ALGORITHM' shadowAlgorithm 
  4. shadowAlgorithm ::=
  5.   'TYPE' '(' 'NAME' '=' algorithmType ',' propertiesDefiinition ')'
  7. algorithmType ::=
  8.   string
  10. propertiesDefinition ::=
  11.   'PROPERTIES' '(' key '=' value (',' key '=' value)* ')'
  13. key ::=
  14.   string
  16. value ::=
  17.   literal

Supplement

  • algorithmType currently supports VALUE_MATCH, REGEX_MATCH and SQL_HINT.

Example

  • Alter default shadow algorithm
  1. ALTER DEFAULT SHADOW ALGORITHM TYPE(NAME="SQL_HINT");

Reserved word

ALTER, DEFAULT, SHADOW, ALGORITHM, TYPE, NAME, PROPERTIES