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 vote262 views1 answer
User defined variables in sql
SQL
1 vote255 views1 answer
Decalre temp table sql
SQL
0 vote275 views2 answers
Call to undefined function mysql_query()
SQL
0 vote511 views1 answer
Power bi connect to postgresql
SQL
0 vote322 views1 answer
What is common table expression in sql
SQL
0 vote285 views1 answer
Add super privilege mysql
SQL
1 vote238 views1 answer
Show indices in mysql table
SQL
0 vote273 views1 answer
SQL division of an integer by another integer get float CAST
SQL
0 vote261 views1 answer
Sql datediff db2
SQL
0 vote238 views2 answers
Change database postgres
SQL