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 vote254 views1 answer
Cannot start database server xampp mac os
SQL
7 votes200 views2 answers
N highest salary in sql
SQL
0 vote189 views1 answer
Run postgresql dump to csv
SQL
0 vote187 views1 answer
Oracle last character of string
SQL
0 vote189 views1 answer
MySql count occurences more than"
SQL
4 votes222 views2 answers
Oracle unliock account
SQL
2 votes212 views1 answer
Sql find not in list
SQL
0 vote189 views1 answer
Sql select with apostrohpe
SQL
1 vote191 views1 answer
How to get the date diff on once field in sql server
SQL
5 votes224 views1 answer
How to use rank function in sql
SQL