Retro Eye care Haitian Deep Dark Default

DROP SHARDING AUDITOR

Description

The DROP SHARDING AUDITOR syntax is used to drop sharding auditors from the current database.

Syntax

DropShardingAuditor ::=
  'DROP' 'SHARDING' 'AUDITOR' ifExists? auditorName (',' auditorName)*

ifExists ::=
  'IF' 'EXISTS'

auditorName ::=
  identifier

Supplement

  • ifExists clause is used to avoid a Sharding auditor not exists error.
  • Sharding auditors referenced by sharding table rules or the default audit strategy cannot be dropped.

Example

  • Drop a sharding auditor
DROP SHARDING AUDITOR sharding_key_required_auditor;
  • Drop multiple sharding auditors with ifExists clause
DROP SHARDING AUDITOR IF EXISTS sharding_key_required_auditor, custom_auditor;

Reserved word

DROP, SHARDING, AUDITOR, IF, EXISTS