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

CREATE DEFAULT SINGLE TABLE RULE

Description

The CREATE DEFAULT SINGLE TABLE RULE syntax is used to create a default single table rule.

Syntax

CreateDefaultSingleTableRule ::=
  'CREATE' 'DEFAULT' 'SINGLE' 'TABLE' 'RULE' singleTableDefinition

singleTableDefinition ::=
  'RESOURCE' '=' resourceName

resourceName ::=
  identifier

Supplement

RESOURCE needs to use data source resource managed by RDL.

Example

Create a default single table rule

CREATE DEFAULT SINGLE TABLE RULE RESOURCE = ds_0;

Reserved word

CREATE, SHARDING, SINGLE, TABLE, RULE, RESOURCE

Reserved word