Deleted table in sql trigger

CREATE TRIGGER tr_audit_delete
ON dbo.customers
AFTER DELETE
AS
BEGIN
    SELECT * FROM DELETED;
END
/*
If you issue a DELETE statement that deletes three rows from the customers
table, the trigger will execute and the SELECT statement will return those 
three rows. If you issue a DELETE statement that deletes no rows from the 
customers table, the trigger will still execute, but the SELECT statement 
will return no rows.

It's important to note that the DELETED table is a temporary, in-memory table 
that is only available within the context of the trigger. It is not a real 
database table, and it is not persisted to disk. The DELETED table is 
automatically created and populated when a trigger is executed, and it is 
automatically dropped when the trigger completes.
*/

Source: youtube.com

Similar codes

16 votes109 views1 answer
Mysql reset auto increment value
SQL
0 vote139 views1 answer
Python connect to mysql in settings.py
SQL
-1 vote110 views3 answers
Mysql get age from date
SQL
-1 vote120 views1 answer
How to open blade file from blade in laravel
SQL
1 vote113 views2 answers
Mysql allow remote connections
SQL
0 vote125 views1 answer
Mostrar datos de tablas relacionadas mysql kjava
SQL
1 vote125 views1 answer
Add many column to sap iq table
SQL
0 vote126 views1 answer
SQL add a totals of differemt rows of the same id
SQL
21 votes127 views5 answers
Oracle all tables
SQL
3 votes125 views1 answer
Kill mysql processlist in whose time more than 200
SQL