DROP SHARDING TABLE REFERENCE RULE
Description
The DROP SHARDING TABLE REFERENCE RULE
syntax is used to drop specified sharding table reference rule.
Syntax
Grammar Railroad diagram
DropShardingTableReferenceRule ::=
'DROP' 'SHARDING' 'TABLE' 'REFERENCE' 'RULE' ifExists? shardingReferenceRuleName (',' shardingReferenceRuleName)*
ifExists ::=
'IF' 'EXISTS'
shardingReferenceRuleName ::=
identifier
Supplement
ifExists
clause is used for avoidSharding reference rule not exists
error.
Example
- Drop a specified sharding table reference rule
DROP SHARDING TABLE REFERENCE RULE ref_0;
- Drop multiple sharding table reference rules
DROP SHARDING TABLE REFERENCE RULE ref_0, ref_1;
- Drop sharding table reference rule with
ifExists
clause
DROP SHARDING TABLE REFERENCE RULE IF EXISTS ref_0;
Reserved word
DROP
, SHARDING
, TABLE
, REFERENCE
, RULE
Related links
当前内容版权归 ShardingSphere 或其关联方所有,如需对内容或内容相关联开源项目进行关注与资助,请访问 ShardingSphere .