复古 护眼 海天 深邃 暗黑 默认

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;

保留字

DROPSHARDINGTABLEREFERENCERULE

相关链接