Preventing table deletion
Fresh Fruit Delivery wants to prevent its regular employees from deleting tables from the database.
この演習はコースの一部です
Building and Optimizing Triggers in SQL Server
演習の手順
- Create a new trigger,
PreventTableDeletion, to prevent table deletion. - The trigger should roll back the firing statement, so the deletion does not happen.
実践的なインタラクティブ演習
このサンプルコードを完成させて、この演習に挑戦してみましょう。
-- Add a trigger to disable the removal of tables
CREATE TRIGGER ___
ON DATABASE
FOR ___
AS
RAISERROR ('You are not allowed to remove tables from this database.', 16, 1);
-- Revert the statement that removes the table
___;