DML Trigger Snippet 1

DML_Trigger_Snippet_1.sql

use master;
GO
CREATE DATABASE TriggerDatabase;
GO
use TriggerDatabase;
GO
CREATE TABLE dbo.Customers
( 
	CustomerName Varchar(10) NOT NULL 
)
GO
CREATE TRIGGER dbo.Customers_AfterDelete 
    ON dbo.Customers
 AFTER DELETE
AS
BEGIN
	PRINT 'After Delete'
END
GO
DELETE FROM Customers 
 WHERE 1=0
GO
DROP TRIGGER dbo.Customers_AfterDelete
GO
--Results
--After Delete

--(0 row(s) affected)