Show TOC

DROP SYSTEM TRIGGER Statement (drop_system_trigger_statement)Locate this document in the navigation structure

Use

The DROP SYSTEM TRIGGER statement ( drop_system_trigger_statement) deletes a system trigger.

Structure
				
<drop_system_trigger_statement>::=
  DROP SYSTEM TRIGGER [<schema_name>.]<trigger_name>

Explanation

If a schema is not specified before the trigger name, the current schema is implicitly assumed.

The current database user must be the owner of the system trigger.

Metadata for the system trigger is deleted.