Get startedGet started for free

Preventing table deletion

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

This exercise is part of the course

Building and Optimizing Triggers in SQL Server

View Course

Exercise instructions

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

Hands-on interactive exercise

Have a go at this exercise by completing this sample code.

-- 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
    ___;
Edit and Run Code