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

2 votes278 views3 answers
Mysql cheat sheet
SQL
3 votes197 views1 answer
Oracle rollback
SQL
0 vote250 views1 answer
Oracle list user locked
SQL
4 votes227 views3 answers
NOT NULL SQL
SQL
11 votes196 views4 answers
Query DISTINCT
SQL
1 vote202 views2 answers
Mysql filter by date mount
SQL
0 vote237 views1 answer
Error code 1451 sql
SQL
0 vote205 views5 answers
Mode sql course
SQL
0 vote209 views1 answer
Avoid duplicate in one to many relationship join in sql
SQL
2 votes200 views1 answer
Set column to not null mysql
SQL