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

0 vote127 views1 answer
MySQL import data from large CSV file
SQL
2 votes118 views1 answer
Mariadb json select
SQL
0 vote123 views1 answer
Get who is hired in february in sql
SQL
0 vote121 views1 answer
What is the difference between now() and current_date()?
SQL
0 vote103 views1 answer
Inser into example
SQL
0 vote121 views1 answer
Mysql update from n to 100
SQL
6 votes119 views2 answers
Mysql concatenate two columns into one
SQL
0 vote74 views1 answer
FindAllBy
SQL
0 vote128 views1 answer
How to list function in psql
SQL
2 votes119 views1 answer
Apex execute batch job
SQL