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.