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 vote267 views1 answer
Wordpress sql find and replace
SQL
0 vote296 views1 answer
Mysql 5.6 hierarchical recursive query
SQL
1 vote303 views1 answer
Search for replace in mysql
SQL
6 votes295 views1 answer
Postgres get size of database
SQL
0 vote306 views1 answer
Left join vs inner join performance
SQL
0 vote286 views1 answer
Mysql find db contarint
SQL
0 vote308 views1 answer
What is initial catalog in sql connection string
SQL
0 vote301 views1 answer
Postgres row expiration
SQL
3 votes287 views1 answer
Select nextval from sequence sql
SQL
3 votes301 views3 answers
Start postgresql ubuntu
SQL