The following triggers are contained in your table:
Trigger | Event | Table | Statement | Timing | next columns... |
|---|---|---|---|---|---|
new_employee | INSERT | employee | IF NEW.profession... | BEFORE | ... |
notify_manager | INSERT | employee | BEGIN...IF... | BEFORE | ... |
new_check | INSERT | employee | SET @var=... | BEFORE | ... |
set_salary | INSERT | employee | SET NEW.salary... | BEFORE | ... |
check_salary | UPDATE | employee | IF NEW.salary... | BEFORE | ... |
not_cut_salary | UPDATE | employee | IF NEW.salary... | BEFORE | ... |
check_owner | DELETE | employee | IF OLD.name... | BEFORE | ... |
check_task | UPDATE | manager | IF NEW.task... | BEFORE | ... |
How can you remove the trigger new_employee? Type the command.