ShardingSphere > Reference > DistSQL > Syntax > RDL Syntax > Rule Definition > Sharding > CREATE BROADCAST TABLE RULE

CREATE BROADCAST TABLE RULE

Description

The CREATE BROADCAST TABLE RULE syntax is used to create broadcast table rules for tables that need to be broadcast (broadcast tables)

CreateBroadcastTableRule ::=
  'CREATE' 'BROADCAST' 'TABLE' 'RULE'  tableName (',' tableName)* 

tableName ::=
  identifier

tableName can use an existing table or a table that will be created;
Only one broadcast rule can exist, but can contain multiple broadcast tables, so can not execute CREATE BROADCAST TABLE RULE more than one time.

-- Add t_province, t_city to broadcast table rules
CREATE BROADCAST TABLE RULE t_province, t_city;

CREATE, BROADCAST, TABLE, RULE