DROP SHADOW RULE
Description
The DROP SHADOW RULE
syntax is used to drop shadow rule for specified database
Syntax
Grammar Railroad diagram
DropShadowRule ::=
'DROP' 'SHADOW' 'RULE' ifExists? shadowRuleName ('FROM' databaseName)?
ifExists ::=
'IF' 'EXISTS'
shadowRuleName ::=
identifier
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 is used for avoidShadow rule not exists
error.
Example
- Drop shadow rule for specified database
DROP SHADOW RULE shadow_rule FROM shadow_db;
- Drop shadow rule for current database
DROP SHADOW RULE shadow_rule;
- Drop shadow rule with
ifExists
clause
DROP SHADOW RULE IF EXISTS shadow_rule;
Reserved word
DROP
, SHODOW
, RULE
, FROM
Related links
当前内容版权归 ShardingSphere 或其关联方所有,如需对内容或内容相关联开源项目进行关注与资助,请访问 ShardingSphere .