ALTER DEFAULT SINGLE TABLE RULE

Description

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

Syntax

  1. AlterDefaultSingleTableRule ::=
  2. 'ALTER' 'DEFAULT' 'SINGLE' 'TABLE' 'RULE' singleTableDefinition
  3. singleTableDefinition ::=
  4. 'RESOURCE' '=' resourceName
  5. resourceName ::=
  6. identifier

Supplement

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

Example

Alter a default single table rule

  1. ALTER DEFAULT SINGLE TABLE RULE RESOURCE = ds_0;

Reserved word

ALTER, SHARDING, SINGLE, TABLE, RULE, RESOURCE