CREATE DEFAULT SINGLE TABLE RULE

Description

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

Syntax

  1. CreateDefaultSingleTableRule ::=
  2.   'CREATE' 'DEFAULT' 'SINGLE' 'TABLE' 'RULE' singleTableDefinition
  4. singleTableDefinition ::=
  5.   'RESOURCE' '=' resourceName
  7. resourceName ::=
  8.   identifier

Supplement

  • RESOURCE needs to use data source resource managed by RDL.

Example

Create a default single table rule

  1. CREATE DEFAULT SINGLE TABLE RULE RESOURCE = ds_0;

Reserved word

CREATE, SHARDING, SINGLE, TABLE, RULE, RESOURCE