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.
Diese Übung ist Teil des Kurses
Building and Optimizing Triggers in SQL Server
Interaktive Übung
Versuche dich an dieser Übung, indem du diesen Beispielcode vervollständigst.
-- Remove the trigger
___ TRIGGER PreventNewDiscounts;