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

10 votes121 views4 answers
Inner join in update query mysql
SQL
0 vote102 views1 answer
Hw to delete a procedure in pl sql
SQL
31 votes116 views3 answers
Sql count
SQL
0 vote107 views1 answer
How to check replication lag in mySQL
SQL
2 votes113 views3 answers
How to get second highest salary in each department in sql
SQL
1 vote113 views1 answer
Oracle case
SQL
2 votes95 views3 answers
Mysql unix timestamp to date
SQL
0 vote138 views1 answer
Alternative for LIMIT sql
SQL
0 vote108 views1 answer
Sql get user account
SQL
19 votes103 views6 answers
Sql create table
SQL