1. 学习
    2. /
  2. 课程
    3. /
  3. Building and Optimizing Triggers in SQL Server
Connected

练习

Preventing table deletion

Fresh Fruit Delivery wants to prevent its regular employees from deleting tables from the database.

说明

100 XP
  • Create a new trigger, PreventTableDeletion, to prevent table deletion.
  • The trigger should roll back the firing statement, so the deletion does not happen.