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 vote186 views1 answer
ORA-32794: cannot drop a system-generated sequence
SQL
1 vote147 views1 answer
ALL_TAB_PARTITIONS
SQL
0 vote169 views1 answer
Load data infile mariadb slow
SQL
1 vote169 views1 answer
Sql list all procedures
SQL
6 votes149 views1 answer
Sqlite foreign key
SQL
5 votes155 views2 answers
Mysql import gzip db
SQL
0 vote144 views1 answer
Oracle activate program
SQL
0 vote155 views1 answer
Group by join columns per table
SQL
4 votes153 views1 answer
Mac install mysql
SQL
0 vote150 views1 answer
Low level operator in dbms
SQL