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

Related links

• Reserved word