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 vote216 views1 answer
Insert or update sql query
SQL
0 vote208 views1 answer
From _sqlite3 import * ImportError: DLL load failed: Das angegebene Modul wurde nicht gefunden.
SQL
0 vote253 views1 answer
How to add auto increment primary key
SQL
11 votes193 views2 answers
Sql rank
SQL
0 vote202 views1 answer
Get id if is not equal in certain table
SQL
4 votes210 views1 answer
Create db table
SQL
0 vote240 views3 answers
Postgres trim string
SQL
6 votes227 views6 answers
Rename column postgres
SQL
6 votes197 views1 answer
How to count number of rows in sql
SQL
0 vote191 views1 answer
Mysql select distinct date from timestamp
SQL