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

 

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

Structure

Syntax Syntax

  1. <drop_system_trigger_statement> ::=
      DROP SYSTEM TRIGGER [<schema_name>.]<trigger_name>
    
End of the code.
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.