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

1 vote220 views2 answers
Truncate table sqlite
SQL
0 vote168 views1 answer
Sql runnignsum
SQL
18 votes197 views3 answers
Find column name in database
SQL
0 vote191 views1 answer
Call rest api from postgresql
SQL
44 votes207 views6 answers
Rename command in sql
SQL
22 votes209 views3 answers
Year format in date mysql
SQL
0 vote186 views1 answer
Mysql remove tabs from string
SQL
2 votes193 views1 answer
Get first 2 letter in sql
SQL
1 vote196 views1 answer
How to between in sql
SQL
1 vote174 views1 answer
Minus vs intersect in sql
SQL