1. Learn
    2. /
  2. Courses
    3. /
  3. Building and Optimizing Triggers in SQL Server

Exercise

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.

Instructions 1/3

undefined XP
  • 1

    Remove the PreventNewDiscounts trigger attached to the Discounts table.

  • 2

    Remove the PreventTableDeletion trigger attached to the database.

  • 3

    Remove the DisallowLinkedServers trigger attached at the server level.