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 vote155 views1 answer
Sql find all different values in column
SQL
0 vote201 views1 answer
Execute a stored procedure in another stored procedure in SQL server
SQL
0 vote171 views1 answer
Postgres grep entire database
SQL
10 votes171 views1 answer
All_dependencies
SQL
0 vote156 views1 answer
Mysql_num_fields in mysqli
SQL
0 vote175 views1 answer
Get only one row in mysql
SQL
0 vote153 views1 answer
Starting mysql shell lampp ubuntu
SQL
0 vote171 views1 answer
Sql examples from framework
SQL
0 vote160 views2 answers
Plan d'exécution requete oracle autotracer
SQL
2 votes160 views2 answers
Mysql find max value row
SQL