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 vote210 views1 answer
Postgresql alter table sequence
SQL
3 votes172 views3 answers
Mysqldump: couldn
SQL
5 votes154 views1 answer
Sql first day of current year
SQL
0 vote183 views1 answer
Minus equivalent in my sql
SQL
2 votes267 views2 answers
How to DROP a table in mysql
SQL
0 vote163 views1 answer
Mysql jdbc timezone
SQL
13 votes166 views1 answer
Fetch first 5 rows in oracle sql developer
SQL
1 vote159 views1 answer
Mysql select month and year
SQL
3 votes191 views3 answers
Sql current year
SQL
5 votes157 views2 answers
Sql conn
SQL