Skip to content
User Manual
DistSQL
Syntax
RDL Syntax
Rule Definition
Shadow
ALTER DEFAULT SHADOW ALGORITHM

ALTER DEFAULT SHADOW ALGORITHM

Description

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

Syntax

AlterDefaultShadowAlgorithm ::=
  'ALTER' 'DEFAULT' 'SHADOW' 'ALGORITHM' shadowAlgorithm 

shadowAlgorithm ::=
  'TYPE' '(' 'NAME' '=' algorithmType (',' propertiesDefinition)? ')'
    
algorithmType ::=
  string

propertiesDefinition ::=
  'PROPERTIES' '(' (key '=' value (',' key '=' value)*)? ')'

key ::=
  string

value ::=
  literal

Supplement

  • algorithmType currently supports VALUE_MATCH, REGEX_MATCH and SQL_HINT.

Example

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

Reserved word

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

Related links

CREATE DEFAULT SHADOW ALGORITHMDROP DEFAULT SHADOW ALGORITHM