ShardingSphere > Reference > DistSQL > Syntax > RDL Syntax > Rule Definition > Single Table > ALTER DEFAULT SINGLE TABLE RULE

ALTER DEFAULT SINGLE TABLE RULE

Description

The ALTER DEFAULT SINGLE TABLE RULE syntax is used to alter a default single table rule.

Syntax

AlterDefaultSingleTableRule ::=
  'ALTER' 'DEFAULT' 'SINGLE' 'TABLE' 'RULE' singleTableDefinition

singleTableDefinition ::=
  'RESOURCE' '=' resourceName

resourceName ::=
  identifier

Supplement

RESOURCE needs to use data source resource managed by RDL.

Example

Alter a default single table rule

ALTER DEFAULT SINGLE TABLE RULE RESOURCE = ds_0;

Reserved word

ALTER, SHARDING, SINGLE, TABLE, RULE, RESOURCE

Reserved word