Retro Eye care Haitian Deep Dark Default

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)

Syntax

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

ifNotExists ::=
  'IF' 'NOT' 'EXISTS'

tableName ::=
  identifier

Supplement

  • tableName can use an existing table or a table that will be created;
  • ifNotExists clause is used for avoid Duplicate Broadcast rule error.

Example

Create broadcast table rule

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

Create broadcast table rule with ifNotExists clause

CREATE BROADCAST TABLE RULE IF NOT EXISTS t_province, t_city;

Reserved word

CREATE, BROADCAST, TABLE, RULE