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

6 votes333 views6 answers
Code: 'ER_NOT_SUPPORTED_AUTH_MODE', errno: 1251, sqlMessage: 'Client does not support authentication protocol requested by server; consider upgrading MySQL client', sqlState: '08004', fatal: true
SQL
0 vote360 views5 answers
Mode sql course
SQL
11 votes369 views3 answers
Python sqlite3 create table if not exists
SQL
0 vote321 views1 answer
H2 auto increment and unique
SQL
0 vote330 views1 answer
Drop a field in psql django
SQL
5 votes324 views1 answer
Oracle find foreign key dependencies
SQL
1 vote364 views1 answer
Sql set auto increment back to 0
SQL
0 vote361 views1 answer
Sql commands in android
SQL
0 vote325 views1 answer
Order by monthly in sql
SQL
0 vote391 views1 answer
Sql cursor example multiple columns
SQL