Retro Eye care Haitian Deep Dark Default

DROP BROADCAST TABLE RULE

Description

The DROP BROADCAST TABLE RULE syntax is used to drop broadcast table rule for specified broadcast tables

Syntax

DropBroadcastTableRule ::=
  'DROP' 'BROADCAST' 'TABLE' 'RULE' ifExists? tableName (',' tableName)* 

ifExists ::=
  'IF' 'EXISTS'

tableName ::=
  identifier

Supplement

  • tableName can use the table of existing broadcast rules;
  • ifExists clause is used for avoid Broadcast rule not exists error.

Example

  • Drop broadcast table rule for specified broadcast table
DROP BROADCAST TABLE RULE t_province, t_city;
  • Drop broadcast table rule with ifExists clause
DROP BROADCAST TABLE RULE IF EXISTS t_province, t_city;

Reserved word

DROP, BROADCAST, TABLE, RULE