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 vote387 views1 answer
Add created and updatedAt fields in mysql
SQL
0 vote347 views1 answer
Postgresql print variable
SQL
4 votes354 views1 answer
Is there any command to change postgres password
SQL
0 vote348 views1 answer
How to get table current identity value in sql server
SQL
16 votes356 views2 answers
Add column to all tables after first column mysql
SQL
4 votes385 views1 answer
List tables sqlite
SQL
7 votes383 views3 answers
Add primary key to database sql
SQL
8 votes381 views1 answer
Oracle search text in all packages
SQL
0 vote367 views1 answer
Mysql subtract month from timestamp
SQL
0 vote387 views1 answer
Postgresql like
SQL