Removing unwanted triggers
After some time, the Fresh Fruit Delivery company notices that some of the triggers they requested are no longer needed. Their workflow has changed and not all of the triggers are used now.
It's a good practice to have your database clean and up-to-date. Unused objects should always be removed after proper confirmation from the involved parties.
The company calls to ask you to help them remove the unused triggers.
This exercise is part of the course
Building and Optimizing Triggers in SQL Server
Hands-on interactive exercise
Have a go at this exercise by completing this sample code.
-- Remove the trigger
___ TRIGGER PreventNewDiscounts;