DROP SHARDING TABLE REFERENCE RULE

描述

DROP SHARDING TABLE REFERENCE RULE 语法用删除指定的关联规则

语法定义

语法 铁路图

DropShardingTableReferenceRule ::=
  'DROP' 'SHARDING' 'TABLE' 'REFERENCE' 'RULE' ifExists? shardingReferenceRuleName (',' shardingReferenceRuleName)*
ifExists ::=
  'IF' 'EXISTS'
shardingReferenceRuleName ::=
  identifier

补充说明

• ifExists 子句用于避免 Sharding reference rule not exists 错误。

示例

• 删除单个关联规则

DROP SHARDING TABLE REFERENCE RULE ref_0;

• 删除多个关联规则

DROP SHARDING TABLE REFERENCE RULE ref_0, ref_1;

• 使用 ifExists 子句删除关联规则

DROP SHARDING TABLE REFERENCE RULE IF EXISTS ref_0;

保留字

DROP、SHARDING、TABLE、REFERENCE、RULE

相关链接

• 保留字