Retro Eye care Haitian Deep Dark Default

ShardingSphere > Reference > DistSQL > Syntax > RDL Syntax > Rule Definition > Sharding > DROP SHARDING TABLE RULE

DROP SHARDING TABLE RULE

Description

The DROP SHARDING TABLE RULE syntax is used to drop sharding table rule for specified database.

Syntax

DropShardingTableRule ::=
  'DROP' 'SHARDING' 'TABLE' 'RULE'  shardingRuleName (',' shardingRuleName)*  ('FROM' databaseName)?

shardingRuleName ::=
  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.

Example

Drop mutiple sharding table rules for specified database.

DROP SHARDING TABLE RULE t_order, t_order_item FROM test1;

Drop a sharding table rule for current database.

DROP SHARDING TABLE RULE t_order;

Reserved word

DROP, SHARDING, TABLE, RULE, FROM

Reserved word