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 vote321 views3 answers
ChAnge TABLE name apex oracle
SQL
0 vote335 views1 answer
NLS_NCHAR_CHARACTERSET
SQL
57 votes570 views5 answers
How to create a new user in postgresql
SQL
1 vote321 views1 answer
Sql select where id not exists in another table
SQL
6 votes335 views1 answer
Wordpress change user password sql
SQL
4 votes377 views6 answers
List all tables in postgres
SQL
0 vote365 views1 answer
How to make sure two tables have same exact data in sql
SQL
1 vote343 views1 answer
Postgresql round double precision
SQL
1 vote334 views2 answers
Change table name phpmyadmin
SQL
4 votes312 views1 answer
Wilayah indonesia database
SQL